Re: Commit rules or Commit trigger - Mailing list pgsql-general

From Vivek Khera
Subject Re: Commit rules or Commit trigger
Date
Msg-id C2700E17-5EFD-4BF2-AFBC-C156E3667B6C@khera.org
Whole thread Raw
In response to Commit rules or Commit trigger  ("Claudio Tognolo" <claudio.tognolo@gmail.com>)
Responses Re: Commit rules or Commit trigger
List 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?

pgsql-general by date:

Previous
From: alexandre - aldeia digital
Date:
Subject: Re: pg_dump -t <> pg_restore -t
Next
From: Vivek Khera
Date:
Subject: Re: Please comment on the following OpenFTS/tsearch2 issues!