Trigger Blunder

Поиск
Список
Период
Сортировка
От ryan@paymentalliane.net
Тема Trigger Blunder
Дата
Msg-id 3a9f1e66.428507060@news.postgresql.org
обсуждение исходный текст
Ответы Re: Trigger Blunder
Список pgsql-general
I had smoe truggers I wanted to get rid of - instead of doing a DROP
TRIGGER sql command, I deleted the trigger records from the pg_trigger
table.... it was late.... i don't know what I was thinking!

Anyhow - now when I try to delete anything from these tables, or
delete the tables themself I get the message:

RelationBuildTriggers: 1 record(s) not found for rel tablename

Any suggestions on how I can deal with this other than recreating the
entire DB?  Or restoring from backup?

Thanks

Ryan Mahoney

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

Предыдущее
От: "K. Ari Krupnikov"
Дата:
Сообщение: pipes in sql
Следующее
От: Patrik Kudo
Дата:
Сообщение: Thought on OIDs