pg_dump fails to lock partitioned tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: pg_dump fails to lock partitioned tables
Date: 2021-10-16 01:05:27
Message-ID: 1018205.1634346327@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While fooling with something else, I happened to notice $SUBJECT.
The reason turns out to be that it's checking the wrong element
of the tblinfo[] array; see one-liner fix attached.

I had a feeling of deja vu about this bug, and indeed a dig in
the git history shows that we fixed it in passing in 403a3d91c.
But that later got reverted, and we forgot to keep the bug fix.

regards, tom lane

Attachment Content-Type Size
make-pg-dump-lock-partition-parents-too.patch text/x-diff 522 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2021-10-16 02:14:46 Re: Trivial doc patch
Previous Message Andres Freund 2021-10-15 22:47:05 Re: [RFC] building postgres with meson