Re: ADD/DROP CONSTRAINT and inheritance

On Wed, 23 May 2001, Christopher Kings-Lynne wrote:

> For the add/drop constraint clauses would it be an idea to change the syntax
> to:
> 
> ALTER TABLE [ ONLY ] x ADD CONSTRAINT x;
> ALTER TABLE [ ONLY ] x DROP CONSTRAINT x;
> 
> So that people can specify whether the constraint should be inherited or
> not?

I'm not sure.  I don't much use the inheritance stuff, so I'm not sure
what would be better for them.  Hopefully one of the people interested
in inheritance will speak up. :)  Technically it's probably not difficult
to do.

A related question is whether or not you can drop a constraint on a
subtable that's inherited from a parent.