Re: Commit rules or Commit trigger

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Commit rules or Commit trigger
Date: 2006-04-27 14:17:51
Message-ID: C2700E17-5EFD-4BF2-AFBC-C156E3667B6C@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:

> I am developing a temporal database and I have the necessity to
> control the integrity constraints befor the commit of the transiction.
> I cannot use the deferrable checking because the integrity
> constraints is a select and i cannot use the trigger or rule because
> the event parameter not support the commit event.
> You have some idea?

My understanding is that deferred constraints are not checked until
commit time, which seems to be what you want. Why do you believe
otherwise?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2006-04-27 14:45:22 Re: Please comment on the following OpenFTS/tsearch2 issues!
Previous Message Bruno Wolff III 2006-04-27 12:59:50 Re: Problem with complex outer join expression