Albert Vernon Smith wrote:
CREATE FUNCTION "return_one_id" () RETURNS "trigger" AS '
Is there any reason you force your identifiers to be case sensitive? > CREATE TRIGGER return_one_id BEFORE INSERT OR UPDATE ON two FOR EACH >> CREATE TABLE "one" ( >> "one_id" BIGSERIAL, >> "text" text NOT NULL, >> CONSTRAINT "iu_text" UNIQUE (text) >> ) >> CREATE TABLE "two" ( >> "two_id" BIGSERIAL, >> "text" text NOT NULL, >> "one_id" bigint, -- Alban Hertroys [EMAIL PROTECTED] magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede //Showing your Vision to the World// ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
