Problem after deleting pg_trigger

Поиск
Список
Период
Сортировка
От Danilo Costa Viana
Тема Problem after deleting pg_trigger
Дата
Msg-id 20030706142046.A89D3B42167@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-admin
<p>I was importing a database and acidently duplicated all my triggers. I was searching for a way to delete the
duplicatedtriggers and found the table pg_trigger. I tought that if I deleted all the records in that table, I could
recreatethe triggers. So I executed the command DELETE FROM pg_trigger.<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>Afterthat I can´t enter the database anymore. I discovered that I deleted one row of pg_trigger that
referencespg_shadow, but I can´t enter the database to recreate the trigger I deleted. Anyone know a way of recreating
thistrigger without entering the database? (maybe copying from another place).<p>Thanks. 

В списке pgsql-admin по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Pls. help me to clarify my doubts.
Следующее
От: "Soeren Laursen"
Дата:
Сообщение: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error