From 4969076c15f73371401ee65f2e4617439239cd8b Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Thu, 22 Oct 2020 23:20:25 +0200
Subject: Database: import ESRI VERTCS that uses a (geodetic) datum to express
 ellipsoidal height

---
 data/sql/proj_db_table_defs.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'data/sql/proj_db_table_defs.sql')

diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql
index 60a12209..ad3686d9 100644
--- a/data/sql/proj_db_table_defs.sql
+++ b/data/sql/proj_db_table_defs.sql
@@ -106,7 +106,7 @@ FOR EACH ROW BEGIN
     SELECT RAISE(ABORT, 'insert on usage violates constraint: extent must not be deprecated when object is not deprecated')
         WHERE EXISTS (
             SELECT 1 FROM extent JOIN object_view o WHERE
-                NOT (o.table_name IN ('projected_crs', 'conversion') AND o.auth_name = 'ESRI') AND
+                NOT (o.table_name IN ('projected_crs', 'vertical_crs', 'vertical_datum', 'conversion') AND o.auth_name = 'ESRI') AND
                 o.table_name = NEW.object_table_name AND
                 o.auth_name = NEW.object_auth_name AND
                 o.code = NEW.object_code AND
-- 
cgit v1.2.3

