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
alban@magproductions.nl
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//