Problem after deleting pg_trigger

From: Danilo Costa Viana <dcviana(at)dobrasil(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problem after deleting pg_trigger
Date: 2003-07-06 14:20:49
Message-ID: 20030706142046.A89D3B42167@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<P>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.</P>
<P>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.</P>
<P>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).</P>
<P>Thanks.</P>

Attachment Content-Type Size
unknown_filename text/html 801 bytes

Browse pgsql-admin by date

  From Date Subject
Next Message Soeren Laursen 2003-07-06 17:57:12 Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error
Previous Message Gaetano Mendola 2003-07-06 09:44:46 Re: Pls. help me to clarify my doubts.