Re: Trigger

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)uk>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger
Date: 2003-10-22 19:07:00
Message-ID: Pine.LNX.4.33.0310221306330.12830-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

  • Trigger at 2003-10-22 13:01:16 from Peter Childs

Responses

  • Re: Trigger at 2003-10-22 22:43:41 from Peter Eisentraut
  • Re: Trigger at 2003-10-23 07:16:27 from Peter Childs

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Rawnsley 2003-10-22 19:18:37 Re: [Erserver-general] alternate eRServer build
Previous Message Dennis Gearon 2003-10-22 19:05:33 Re: Identifier max length