Re: Own messages for constraints? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Own messages for constraints?
Date
Msg-id 9e4684ce0703191126o15938c1j6115e2b123898ea0@mail.gmail.com
Whole thread Raw
In response to Re: Own messages for constraints?  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Own messages for constraints?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
On 3/19/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
> In an AFTER trigger you can be sure you're seeing what actually got
> inserted. In a BEFORE trigger other triggers after you could still
> modify the data...

yes but in after trigger the only thing you can do is to raise
exception. you cannot fix the data, issue warning, or simply stop the
insert/update without breaking the transaction.

depesz

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Own messages for constraints?
Next
From: Tom Lane
Date:
Subject: Re: Possible planner bug?