Re: Trigger - Mailing list pgsql-general

From scott.marlowe
Subject Re: Trigger
Date
Msg-id Pine.LNX.4.33.0310221306330.12830-100000@css120.ihs.com
Whole thread Raw
In response to Trigger  (Peter Childs <blue.dragon@blueyonder.co.uk>)
Responses Re: Trigger
Re: Trigger
List pgsql-general
On Wed, 22 Oct 2003, Peter Childs wrote:

>     Is it possible to deferr a trigger until commit, Or to have the
> trigger not occur if the transaction is rolled back? Like transaction.
>     I think its possible since constraints use triggers and if so why
> is this a standard feature.
>     Also is there anyway of seeing what triggers exsist and what they
> do? (psql \<somthing> or the like)

A trigger inside a transaction should automagically roll back should the
transaction fail, shouldn't it?


pgsql-general by date:

Previous
From: Andrew Rawnsley
Date:
Subject: Re: [Erserver-general] alternate eRServer build
Next
From: Jeff Eckermann
Date:
Subject: Re: plpgsql: return multiple result sets or temp table