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