Changeset 317 for wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm

Timestamp:

05/28/06 17:44:12 (6 years ago)

Author:

dom

Message:

Delete orphaned content/metadata rows in Pg setup (closes #10)

Files:

• wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm (modified) (2 diffs)

wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Pg.pm

@@ -93 +93 @@
         (SELECT id FROM node where node.name = content.name)
 |, qq|
+DELETE FROM content WHERE node_id IS NULL;
 ALTER TABLE content ALTER COLUMN node_id SET NOT NULL;
 ALTER TABLE content DROP COLUMN name;
@@ -104 +105 @@
         (SELECT id FROM node where node.name = metadata.node)
 |, qq|
+DELETE FROM metadata WHERE node_id IS NULL;
 ALTER TABLE metadata ALTER COLUMN node_id SET NOT NULL;
 ALTER TABLE metadata DROP COLUMN node;