On Tue, 20 Mar 2001, chris markiewicz wrote:
> 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?
Okay... (you should really use drop trigger, not deleting from
pg_trigger).
You need to set reltriggers on the pg_class row for the table.
Probably something like:
update pg_class set reltriggers=4 where relname='accessor_group';
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
