Postgres Pro
Downloads
Home   >   mailing lists

Re: Deferrerable Check constraints - Mailing list pgsql-novice

From Tom Lane
Subject Re: Deferrerable Check constraints
Date
Msg-id 17501.1227534855@sss.pgh.pa.us
Whole thread Raw
In response to Deferrerable Check constraints  ("Luiz K. Matsumura" <luiz@planit.com.br>)
List pgsql-novice
Tree view 
"Luiz K. Matsumura" <luiz@planit.com.br> writes:
> Need a Help. Can a check constraint be deferred until the end of a
> transaction  ?

Nope, sorry.

If you're desperate to have such functionality you could check the
condition in a "constraint trigger".
http://www.postgresql.org/docs/8.3/static/sql-createconstraint.html

            regards, tom lane

pgsql-novice by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Deferrerable Check constraints
Next
From: Bruce Hyatt
Date:
Subject: Re: Deferrerable Check constraints