Re: triggers

Dennis Gearon wrote:
> So,
> I can make all the changes I want within a transaction, and no related triggers fire before
> the changes are are committed, right?
> The triggers work on the image of the data before the transaction is BEGINs,
> PLUS what it would look like with ALL UPDATES/DELETES in the tranaction being successfull?
> And there's now way to tell which triggers on what tables affected in the transaction will
> fire first, right?

In 7.3, triggers fire in alphabetical order, as do rules.

AFTER triggers are most needed when you need to see a value assigned by
the primary command, like the sequence number assigned to a column.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073