From: Bruno Wolff III <bruno@wolff.to>
To: frank@joerdens.de
Cc: pgsql-sql@postgresql.org
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Date: Wed, 30 Mar 2005 11:52:32 -0600
Message-ID: <20050330175232.GB17708@wolff.to> (raw)
In-Reply-To: <20050330103311.GB10376@mail.archi-me-des.de>
References: <20050330090732.GA10376@mail.archi-me-des.de>
<op.sof2u5gmth1vuj@localhost>
<20050330103311.GB10376@mail.archi-me-des.de>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bruno@wolff.to, frank@joerdens.de
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
In-Reply-To: <20050330175232.GB17708@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox