RE: finding and removing a constraint...

okay, i screwed up. i dropped some triggers from a table. now that table
is not accessible to me.

can't drop it...can't select...can't pg_dump.

message is error: RelationBuildTriggers: 2 record(s) not found for rel
accessor_group

or a pg_dump results in: getTables(): relation 'accessor_group': 6 Triggers
were expected, but got 4.

is there any way that i can re-insert them?

if i'm screwed, then how do i drop this table?

i really appreciate your help.

chris

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of chris markiewicz
Sent: Tuesday, March 20, 2001 3:16 PM
To: 'PostgreSQL-general'
Subject: finding and removing a constraint...

hello

i am trying to remove a foreign key that i placed on a database. what is
the easiest way to find/delete the constraint?

thanks
chris

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html