Re: insert serial numbers - Mailing list pgsql-general

From Alban Hertroys
Subject Re: insert serial numbers
Date
Msg-id 43BB9BAB.4@magproductions.nl
Whole thread Raw
In response to Re: insert serial numbers  (Albert Vernon Smith <contact1@absentia.com>)
List pgsql-general
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//

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: generic way to retrieve array as rowset
Next
From: Robert Osowiecki
Date:
Subject: Unique transaction ID