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

On Wed, Mar 30, 2005 at 10:52:42 -0700, Michael Fuhr <mike@fuhr.org> wrote:
> On Wed, Mar 30, 2005 at 11:52:32AM -0600, Bruno Wolff III wrote:
> > 
> > What version of Postgres are you running? I think ALTER CONSTRAINT is a
> > relatively recent addition.
> 
> Where are you seeing ALTER CONSTRAINT?  I don't see it in gram.y
> even in HEAD.

I guess only in the previous messages in the thread.
I remembered some recent additions to the ALTER TABLE command and incorrectly
assumed that ALTER CONSTRAINT was one of those.

It does look like you can only ADD and DROP constraints, not directly
alter or replace them. So making a reference deferable is go to require
a DROP and ADD which will need to recheck the constraint.