Re: Trigger Blunder

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Trigger Blunder
Дата
Msg-id 3185.983544705@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Trigger Blunder  (ryan@paymentalliane.net)
Ответы Re: Trigger Blunder
Список pgsql-general
ryan@paymentalliane.net writes:
> 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

Reset the "reltriggers" count (field in pg_class) to zero for each
affected table.

            regards, tom lane

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

Предыдущее
От: "Gregory Wood"
Дата:
Сообщение: Re: serial properties
Следующее
От: Jose Manuel Lorenzo Lopez
Дата:
Сообщение: Re: Re: Help with pq++