Re: Deferrerable Check constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Deferrerable Check constraints
Date: 2008-11-24 13:54:15
Message-ID: 17501.1227534855@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Hyatt 2008-11-24 18:35:49 Re: Deferrerable Check constraints
Previous Message Luiz K. Matsumura 2008-11-24 13:40:18 Deferrerable Check constraints