I was importing a database and acidently duplicated all my triggers. I was searching for a way to delete the duplicated triggers and found the table pg_trigger. I tought that if I deleted all the records in that table, I could recreate the triggers. So I executed the command DELETE FROM pg_trigger.

After that, everytime I try to enter my database, postgres gives me that error message: FATAL 1: RelationBuildTriggers: 1 record(s) not found for rel pg_shadow.

After that I canīt enter the database anymore. I discovered that I deleted one row of pg_trigger that references pg_shadow, but I canīt enter the database to recreate the trigger I deleted. Anyone know a way of recreating this trigger without entering the database? (maybe copying from another place).

Thanks.