drop constraint unnamed? - Mailing list pgsql-general

From Andy Kriger
Subject drop constraint unnamed?
Date
Msg-id OJEFIHHAALOBKKJEOMBDGEAKCDAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: drop constraint unnamed?  (Darren Ferguson <darren@crystalballinc.com>)
Re: drop constraint unnamed?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
How do you drop an unnamed constraint from a table? I tried searching the
archives but the site is extremely slow and I need to get this fixed now.

I have tried
alter table table drop constraint <unnamed>;
alter table table drop constraint '<unnamed>';
alter table table drop constraint '';
alter table table drop constraint;
drop trigger triggerName from table;
drop trigger 'triggerName' from table;

Any ideas?

thx
andy



pgsql-general by date:

Previous
From: Diogo Biazus
Date:
Subject: PostgreSQL Benchmarks
Next
From: Darren Ferguson
Date:
Subject: Re: drop constraint unnamed?