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?
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