Build: simplify proj.db generation (#2605)

- change foreign key check, so that it is enabled outside of the
  transaction where we insert things, and can make the sqlite3
  process fail in case of violations, without the postcheck done
  in the autoconf build
- autoconf and cmake builds: simplification related to the above
  (which also means that cmake builds now have the fkey check, which
  was omitted until now)

1 files changed, 1 insertions, 6 deletions

diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index a580f6e0..9f2356f4 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -9,11 +9,6 @@ CREATE INDEX grid_transformation_idx ON grid_transformation(source_crs_auth_name
 CREATE INDEX other_transformation_idx ON other_transformation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
 CREATE INDEX concatenated_operation_idx ON concatenated_operation(source_crs_auth_name, source_crs_code, target_crs_auth_name, target_crs_code);
 
--- Do an explicit foreign_key_check as foreign key checking is a no-op within
--- a transaction. Unfortunately we can't ask for this to be an error, so this
--- is just for verbose output. In Makefile, we check this separately
-PRAGMA foreign_key_check;
-
 -- Final consistency checks
 CREATE TABLE dummy(foo);
 CREATE TRIGGER final_checks
@@ -190,4 +185,4 @@ INSERT INTO dummy DEFAULT VALUES;
 DROP TRIGGER final_checks;
 DROP TABLE dummy;
 
-VACUUM;
\ No newline at end of file
+VACUUM;