Re: should I worry?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: should I worry?
Дата
Msg-id 3068.1194139280@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: should I worry?  (ohp@pyrenet.fr)
Ответы Re: should I worry?  (ohp@pyrenet.fr)
Список pgsql-hackers
ohp@pyrenet.fr writes:
> Is there a query I can use to know all the unamed trigger, delete them and
> recreate with the right sentence?

I've applied a patch that should persuade the backend to convert the old
CREATE CONSTRAINT TRIGGER commands into proper foreign-key constraints.
I'd suggest applying the patch and re-loading the dump instead of trying
to fix things manually.

http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c.diff?r1=1.219;r2=1.220
        regards, tom lane


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

Предыдущее
От: Jörg Beyer
Дата:
Сообщение: Re: building 8.3beta2 w/ 'make check' consumes A LOT of disk space
Следующее
От: Tom Lane
Дата:
Сообщение: Profiling vs autovacuum (was Re: building 8.3beta2 w/ 'make check' consumes A LOT of disk space)