/*
If a table contains two or more foreign keys referencing the same
table and they reference the same record in the other table, the
record's primary key cannot be changed even if the keys have the
"ON UPDATE CASCADE" clause (see example below). It will say that
"referential integrity error - key referenced from `table' not found
in `table'".
*/
CREATE TABLE "Bug1" (
"ID" INT4,
"Description" TEXT NOT NULL,
PRIMARY KEY("ID")
);
CREATE TABLE "Bug2" (
"ID" INT4,
"Source" INT4 NOT NULL
REFERENCES "Bug1" ON UPDATE CASCADE ON DELETE NO ACTION,
"Destination" INT4 NOT NULL
REFERENCES "Bug1" ON UPDATE CASCADE ON DELETE NO ACTION,
"Description" TEXT NOT NULL,
PRIMARY KEY ("ID")
);
INSERT INTO "Bug1" VALUES (1,'Place');
INSERT INTO "Bug2" VALUES (10,1,1,'Move from Place to Place');
UPDATE "Bug1" SET "ID"=2 WHERE "ID"=1;
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
