Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: frank(at)joerdens(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Date: 2005-03-30 17:52:32
Message-ID: 20050330175232.GB17708@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Mar 30, 2005 at 12:33:11 +0200,
frank(at)joerdens(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-03-30 17:52:42 Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Previous Message Bruno Wolff III 2005-03-30 17:26:39 Re: RE : Foreign key