Re: [GENERAL] Order of triggers and sequences...

2006-04-29 Thread Terry Lee Tucker
On Saturday 29 April 2006 08:34 am, Alex Mayrhofer <[EMAIL PROTECTED]> thus communicated: --> 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 "

[GENERAL] Order of triggers and sequences...

2006-04-29 Thread Alex Mayrhofer
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 t