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

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.
Дата
Msg-id dc20d807-1e72-49a8-ac0d-c119631ba9b9@lab.ntt.co.jp
обсуждение исходный текст
Ответ на 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.  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
On 2017/05/09 17:21, Jeevan Ladhe wrote:
> On Tue, May 9, 2017 at 12:43 PM, amul sul <sulamul@gmail.com> wrote:
>> 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?
> 
> 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.

Perhaps, it will be better not to touch the regular inheritance tables in
this patch.

Thanks,
Amit




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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] Bug in pg_dump --table and --exclude-table fordeclarative partition table handling.
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] logical replication syntax (was DROP SUBSCRIPTION,query cancellations and slot handling)