Re: drop constraint unnamed?

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(at)postgresql(dot)org)
>

--
Darren Ferguson