Re: Own messages for constraints?

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>, "Jeff Davis" <pgsql(at)j-davis(dot)com>, "Kacper Chrapa" <k(dot)chrapa(at)wp(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: Own messages for constraints?
Date: 2007-03-19 18:26:13
Message-ID: 9e4684ce0703191126o15938c1j6115e2b123898ea0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/19/07, Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-03-19 18:31:00 Re: Own messages for constraints?
Previous Message Andrej Ricnik-Bay 2007-03-19 18:23:15 Re: UPGRADATION TO 8.1