Unless there are foreign keys and all sorts of other dependencies. As Tom
said, the recipe on http://techdocs.postgresql.org/ is much nicer to deal
with.
Greg
----- Original Message -----
From: "Darren Ferguson" <darren@crystalballinc.com>
To: "Andy Kriger" <akriger@greaterthanone.com>
Cc: "Pgsql-General" <pgsql-general@postgresql.org>
Sent: Monday, October 14, 2002 11:23 AM
Subject: Re: [GENERAL] 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@postgresql.org)
> >
>
> --
> Darren Ferguson
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
