> On Tue, 22 Feb 2000, Bruce Momjian wrote:
>
> > > What about ALTER TABLE table DROP CONSTRAINT? I see this:
>
> > > Note that we seem to have ALTER TABLE table ADD CONSTRAINT, though.
>
> > Perhaps Peter decided to wait for 7.1?
>
I was speaking off DROP COLUMN. Sorry to have added to the confusion.
> Yes and no. I never had anything like this. I was afraid to get crossed up
> with Jan. Anyway, to add/drop unique constraints create/drop the index. To
> add/drop foreign keys, use create/drop constraint trigger(????). To
> add/drop check contraints you're on your own. Not so bad all in all.
>
> --
> Peter Eisentraut Sernanders vaeg 10:115
> peter_e@gmx.net 75262 Uppsala
> http://yi.org/peter-e/ Sweden
>
>
-- 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