drop constraint unnamed?

From: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: drop constraint unnamed?
Date: 2002-10-14 15:25:20
Message-ID: OJEFIHHAALOBKKJEOMBDGEAKCDAA.akriger@greaterthanone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Wood 2002-10-14 15:34:49 Re: Asta with PostgreSQL
Previous Message Darren Ferguson 2002-10-14 15:23:07 Re: drop constraint unnamed?