ALTER TABLE table RENAME TO aaa;
CREATE TABLE table (
columns .....
)
Do it without the constraint
INSERT INTO table (SELECT * FROM aaa);
DROP TABLE aaa;
This is how i would do it although there could be other options
HTH
On Mon, 14 Oct 2002, Andy Kriger wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Darren Ferguson