pg_dump with disable trigger

Поиск
Список
Период
Сортировка
От Soni M
Тема pg_dump with disable trigger
Дата
Msg-id CAAMgDXneQvt1yX6u7XL=LBrAPU1D=tRKCgz6_JGL7+VBHNB5mQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump with disable trigger  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Hello All,

I think I found bug on pg_dump 9.6.8.
The bug arise when using pg_dump with --disable-trigger option.
The command just :
pg_dump -f /tmp/test_disable_trigger.sql -a -b --disable-triggers -t some_table some_database
On the resulted script, it simply did

ALTER TABLE public.some_table DISABLE TRIGGER ALL;
COPY command
ALTER TABLE public.some_table ENABLE TRIGGER ALL;

This become a problem, when the destination table already has Disabled user triggers, it gets enabled by the dump script.
It also altered another kind of trigger like Triggers firing on replica only, get altered to ordinary triggers.

Thanks

--
Regards,

Soni Maula Harriz

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15105: OpenTransientFile() should be paired with CloseTransientFile() rather than close()
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_dump with disable trigger