Postgres Pro
Downloads
Home   >   mailing lists

Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Date
Msg-id 20050330175232.GB17708@wolff.to
Whole thread Raw
In response to Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE  (frank@joerdens.de)
Responses Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
On Wed, Mar 30, 2005 at 12:33:11 +0200, frank@joerdens.de wrote:
> On Wed, Mar 30, 2005 at 11:48:31AM +0200, PFC wrote:
> > 
> >     Checks the docs on ALTER TABLE ... ALTER CONSTRAINT ...
> 
> ALTER CONSTRAINT? I did check for that, and it does not appear to
> exist?! That's why I asked ...

What version of Postgres are you running? I think ALTER CONSTRAINT is a
relatively recent addition.

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: RE : Foreign key
Next
From: Michael Fuhr
Date:
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE