aboutsummaryrefslogtreecommitdiff
path: root/data/sql/proj_db_table_defs.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2020-10-22 23:20:25 +0200
committerEven Rouault <even.rouault@spatialys.com>2020-10-23 00:03:40 +0200
commit4969076c15f73371401ee65f2e4617439239cd8b (patch)
treec21bb3da042c1f7fdf5434021171fd56894b2bba /data/sql/proj_db_table_defs.sql
parent9a112931555aa324ed9caa3c261a4fd11551d615 (diff)
downloadPROJ-4969076c15f73371401ee65f2e4617439239cd8b.tar.gz
PROJ-4969076c15f73371401ee65f2e4617439239cd8b.zip
Database: import ESRI VERTCS that uses a (geodetic) datum to express ellipsoidal height
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
-rw-r--r--data/sql/proj_db_table_defs.sql2
1 files changed, 1 insertions, 1 deletions
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