aboutsummaryrefslogtreecommitdiff
path: root/data/sql/commit.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2020-03-30 11:33:59 +0200
committerEven Rouault <even.rouault@spatialys.com>2020-03-30 12:57:03 +0200
commitda32ee9459cb08df87d5c02a83037158772d1047 (patch)
treeceec9020c8e62af775168b62d2b89dd7c75f14e8 /data/sql/commit.sql
parent64946ab103d66508bf56bf80417bb5d69876bd25 (diff)
downloadPROJ-da32ee9459cb08df87d5c02a83037158772d1047.tar.gz
PROJ-da32ee9459cb08df87d5c02a83037158772d1047.zip
Database: fix registration of custom entries of grid_transformation_custom.sql for geoid grids (fixes #2112)
Diffstat (limited to 'data/sql/commit.sql')
-rw-r--r--data/sql/commit.sql13
1 files changed, 0 insertions, 13 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index a3028586..d090ccb2 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -63,19 +63,6 @@ FOR EACH ROW BEGIN
(SELECT auth_name || code FROM geodetic_crs
WHERE type = 'geographic 2D'));
- -- check that grids with HEIGHT_TO_GEOGRAPHIC3D method are properly registered
- SELECT RAISE(ABORT, 'One grid_transformation with HEIGHT_TO_GEOGRAPHIC3D has not its source_crs in vertical_crs table')
- WHERE EXISTS (SELECT * FROM grid_transformation g WHERE
- g.method_code = 'HEIGHT_TO_GEOGRAPHIC3D' AND
- g.source_crs_auth_name || g.source_crs_code NOT IN
- (SELECT auth_name || code FROM vertical_crs));
- SELECT RAISE(ABORT, 'One grid_transformation with HEIGHT_TO_GEOGRAPHIC3D has not its target_crs in geodetic_crs table with type = ''geographic 3D''')
- WHERE EXISTS (SELECT * FROM grid_transformation g WHERE
- g.method_code = 'HEIGHT_TO_GEOGRAPHIC3D' AND
- g.target_crs_auth_name || g.target_crs_code NOT IN
- (SELECT auth_name || code FROM geodetic_crs
- WHERE type = 'geographic 3D'));
-
-- check that grids with Geographic3D to GravityRelatedHeight method are properly registered
SELECT RAISE(ABORT, 'One grid_transformation with Geographic3D to GravityRelatedHeight has not its target_crs in vertical_crs table')
WHERE EXISTS (SELECT * FROM grid_transformation g WHERE