Search Postgresql Archives

Triggers and Transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I have a question about how much of a trigger is in a transaction. 
I've read the docs and googled around but can't seem to find a
concrete answer.

I have two triggers that are designed to work together, one is a
before trigger and one is an after.  If the before trigger succeeds
then it will have made some changes to one of my tables, however if
the after one fails some how (elog(ERROR, "")? then I would like to
rollback the changes of the before one as well as any made by the
after one too.

Is this possible?

Many thanks

Chris Coleman.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux