Bug in pg_dump --table and --exclude-table for declarative partition table handling.

From: amul sul <sulamul(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug in pg_dump --table and --exclude-table for declarative partition table handling.
Date: 2017-05-09 07:13:27
Message-ID: CAAJ_b94bXL28PqXACEZfWQA0qfmmKrjB3FDhgQOOzFDyYzDVtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
pg_dump_fix_for_partitioned_rel_wip.patch application/octet-stream 2.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2017-05-09 07:15:47 Re: proposal psql \gdesc
Previous Message Amit Kapila 2017-05-09 05:41:54 Remove pre-10 compatibility code in hash index