| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem defining deferred check constraints |
| Date: | 2009-01-25 17:21:59 |
| Message-ID: | 20090125091913.B38711@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 25 Jan 2009, Thomas Kellerer wrote:
> Hi,
>
> I'm playing around with deferred constraints and according to the manual, it
> should be possible to declare a check constraint as deferred.
>
> At least that's how I read the definition of /column_constraint/ at
> http://www.postgresql.org/docs/8.3/static/sql-createtable.html
In the full description in that page for deferrable/not deferrable, it
also states: "Only foreign key constraints currently accept this clause."
Currently, you'd probably need to use a constraint trigger to check the
constraint to get similar functionality.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2009-01-25 18:28:46 | Re: autovacuum daemon |
| Previous Message | Roger Leigh | 2009-01-25 17:07:56 | Re: Custom type, operators and operator class not sorting/indexing correctly |