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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073