diff options
Diffstat (limited to 'util/updates/update_1.22.sql')
-rw-r--r-- | util/updates/update_1.22.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/util/updates/update_1.22.sql b/util/updates/update_1.22.sql index e3729765..9a81b2c6 100644 --- a/util/updates/update_1.22.sql +++ b/util/updates/update_1.22.sql @@ -5,12 +5,11 @@ CREATE TABLE relgraph ( cmap text NOT NULL DEFAULT '' ) WITHOUT OIDS; -SELECT SETVAL('relgraph_id_seq', NEXTVAL('relgraph_seq')); DROP SEQUENCE relgraph_seq; - ALTER TABLE vn ALTER COLUMN rgraph DROP NOT NULL; ALTER TABLE vn ALTER COLUMN rgraph SET DEFAULT NULL; -UPDATE vn SET rgraph = NULL WHERE rgraph = 0; +UPDATE vn SET rgraph = NULL; +ALTER TABLE vn ADD FOREIGN KEY (rgraph) REFERENCES relgraph (id) DEFERRABLE INITIALLY DEFERRED; -- add foreign table constraint to changes.causedby |