Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Order of triggers and sequences...



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group