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@postgresql.org
[mailto:pgsql-general-owner@postgresql.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