[HACKERS] Bug in pg_dump --table and --exclude-table for declarative partitiontable handling. - Mailing list pgsql-hackers

From amul sul
Subject [HACKERS] Bug in pg_dump --table and --exclude-table for declarative partitiontable handling.
Date
Msg-id CAAJ_b94bXL28PqXACEZfWQA0qfmmKrjB3FDhgQOOzFDyYzDVtA@mail.gmail.com
Whole thread Raw
Responses 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.  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: [HACKERS] Remove pre-10 compatibility code in hash index
Next
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] proposal psql \gdesc