> >
> > Those are the two major user-visible loose ends with this feature.
>
> What about ALTER TABLE table DROP CONSTRAINT? I see this:
>
> alter table t1 drop constraint t1_fk cascade;
> ERROR: ALTER TABLE / DROP CONSTRAINT is not implemented
>
> Note that we seem to have ALTER TABLE table ADD CONSTRAINT, though.
I thought that was going in. According to Marc, if it sufficiently
warned users, and required them to type it twice, it would do Peter's
alter table code. Perhaps Peter decided to wait for 7.1?
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026