Re: Listing Triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Listing Triggers
Дата
Msg-id 24961.1012415204@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Listing Triggers  (Brian McCane <bmccane@mccons.net>)
Список pgsql-admin
Brian McCane <bmccane@mccons.net> writes:
>     Thanks Tom and Arguile that definitely helps.  Now for my more
> pressing, but forgotten question.  Shouldn't PostgreSQL have automatically
> dropped that trigger when I dropped the table?

It should, and it does.

IIRC, there's a bug in some versions of pg_dump that loses the
connection between a foreign-key trigger and the referenced table
(ie, the tgconstrrelid link) when you dump and reload.  If you can
exhibit an instance of misbehavior otherwise, I'd like to see it.

            regards, tom lane

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Listing Triggers
Следующее
От: Joshua Franklin
Дата:
Сообщение: Re: postgresql under Windows is slow