On Thursday 20 April 2006 12:25 pm, "Chris Coleman" <chris@xxxxxxxxxxx> thus communicated: --> 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. --> --> ---------------------------(end of broadcast)--------------------------- --> TIP 6: explain analyze is your friend --> The whole process is in a transaction and all of it will be rolled back.
