Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.

Поиск
Список
Период
Сортировка
От Jeevan Ladhe
Тема Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.
Дата
Msg-id CAOgcT0N3JHJKcasd24_Zk-2rpf2Sk4LtTCVBgYoebPysTq-z8g@mail.gmail.com
обсуждение исходный текст
Ответ на [HACKERS] Bug in pg_dump --table and --exclude-table for declarative partitiontable handling.  (amul sul <sulamul@gmail.com>)
Ответы Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.  (Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>)
Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
Hi,

On Tue, May 9, 2017 at 12:43 PM, amul sul <sulamul@gmail.com> wrote:
Hi,

Current pg_dump --exclude-table option excludes partitioned relation
and dumps all its child relations and vice versa for --table option, which
I think is incorrect.

In this case we might need to explore all partitions and exclude or include
from dump according to given pg_dump option, attaching WIP patch proposing
same fix.   Thoughts/Comments?

Regards,
Amul

+1.

Also, I can see similar issue exists with inheritance.
In attached patch, I have extended Amul's original patch to address the
inheritance dumping issue.

Regards,
Jeevan Ladhe
 
Вложения

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] logical replication syntax (was DROP SUBSCRIPTION,query cancellations and slot handling)
Следующее
От: Etsuro Fujita
Дата:
Сообщение: [HACKERS] Typos in comments in execMain.c