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.
