Order of triggers and sequences...

From: Alex Mayrhofer <axelm(at)nona(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Order of triggers and sequences...
Date: 2006-04-29 12:34:16
Message-ID: 44535D48.7040503@nona.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2006-04-29 12:42:55 Re: Order of triggers and sequences...
Previous Message Tom Lane 2006-04-29 01:54:17 Re: [GENERAL] Autovacuum Logging