ALTER TABLE .... make constraint DEFERRABLE

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ALTER TABLE .... make constraint DEFERRABLE
Date: 2010-03-22 13:39:48
Message-ID: 1269265188.8481.513.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Deferrable unique constraints seem an interesting feature, though I have
either some questions or some issues, not sure which.

I don't seem to be able to find any way to do an ALTER TABLE that adds
this new capability to an existing table.

There is no way to add a constraint via a CREATE TABLE AS SELECT, so
that means there is no way to use the feature at all in that case.

Also, foreign keys can't be defined that refer to a deferrable primary
key. That isn't mentioned at all in the manual with regard to the
DEFERRABLE clause, though it is mentioned in the FK section. You get
this error message
ERROR: cannot use a deferrable unique constraint for referenced table

The use case for this feature looks a little narrow at present. Can we
do something about usability?

Am I missing something?

--
Simon Riggs www.2ndQuadrant.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-03-22 13:54:30 Re: Proposal: access control jails (and introduction as aspiring GSoC student)
Previous Message Stephen Frost 2010-03-22 13:39:47 Re: Proposal: access control jails (and introduction as aspiring GSoC student)