diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-02-06 13:43:59 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-02-06 13:43:59 +0100 |
| commit | e9b5f63945e41713515c3abf7995d22e58fa7b95 (patch) | |
| tree | b32b15cf45c9fa1ff5e76c862ee65d1045230364 /data/sql | |
| parent | c077e5b8b19a7c376bec1a68c2d20334236aed09 (diff) | |
| parent | aa2545bebddec14caf4bae8e7615dbb880613faa (diff) | |
| download | PROJ-e9b5f63945e41713515c3abf7995d22e58fa7b95.tar.gz PROJ-e9b5f63945e41713515c3abf7995d22e58fa7b95.zip | |
Merge pull request #1914 from rouault/fix_1913
Fix performance issue, affecting projinfo EPSG:7842
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index b820b207..f34e1799 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1367,6 +1367,8 @@ CREATE TABLE supersession( source TEXT ); +CREATE INDEX idx_supersession ON supersession(superseded_table_name, superseded_auth_name, superseded_code); + CREATE TRIGGER supersession_insert_trigger BEFORE INSERT ON supersession FOR EACH ROW BEGIN |