Re: RE: finding and removing a constraint... - Mailing list pgsql-general

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';