Order of triggers and sequences... - Mailing list pgsql-general

From Alex Mayrhofer
Subject Order of triggers and sequences...
Date
Msg-id 44535D48.7040503@nona.net
Whole thread Raw
Responses Re: Order of triggers and sequences...  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
Hi,

i'm about to implement a trigger on a table with an id field populated by a
sequence (the usual 'id SERIAL NOT NULL PRIMARY KEY').

Just a short (probably lame) question: Would a "BEFORE INSERT" row level
trigger already see a populated 'id' column, or would that happen after all
triggers on the actual insert?

thanks,

Alex


pgsql-general by date:

Previous
From: Dany De Bontridder
Date:
Subject: dump Functions
Next
From: Terry Lee Tucker
Date:
Subject: Re: Order of triggers and sequences...