Re: pg_dump bug for extension owned tables
Fabrízio de Royes Mello <fabriziomello@gmail.com>
From: Fabrízio de Royes Mello <fabriziomello@gmail.com>
To: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-07-13T14:52:23Z
Lists: pgsql-hackers
Attachments
- pg_dump_segfault_on_extension_and_schema_v2.patch (text/x-patch) patch v2
On Sat, Jul 11, 2020 at 8:07 PM Andrew Dunstan < andrew.dunstan@2ndquadrant.com> wrote: > > > On 6/26/20 2:10 PM, Fabrízio de Royes Mello wrote: > > > > On Fri, Jun 26, 2020 at 11:55 AM Fabrízio de Royes Mello > > <fabriziomello@gmail.com <mailto:fabriziomello@gmail.com>> wrote: > > > > > > > > > On Fri, Jun 26, 2020 at 11:24 AM Andrew Dunstan > > <andrew.dunstan@2ndquadrant.com > > <mailto:andrew.dunstan@2ndquadrant.com>> wrote: > > > > > > > > > > > > On 6/26/20 9:57 AM, Andrew Dunstan wrote: > > > > > It appears that for extension owned tables tbinfo.attgenerated isn't > > > > > being properly populated, so line 2050 in REL_12_STABLE, which > > is line > > > > > 2109 in git tip, is failing. > > > > > > > > > > > > > > > > > > Should have mentioned this is in src/bin/pg_dump/pg_dump.c > > > > > > > > > > Having a look on it. > > > > > > > Seems when qualify the schemaname the the "tbinfo->interesting" field > > is not setted for extensions objects, so the getTableAttrs can't fill > > the attgenerated field properly. > > > > I'm not 100% sure it's the correct way but the attached patch works > > for me and all tests passed. Maybe we should add more TAP tests? > > > > > > > I just tried this patch out on master, with the test case I gave > upthread. It's not working, still getting a segfault. > Ohh really sorry about it... my bad... i completely forgot about it!!! Due to my rush I ended up adding the wrong patch version. Attached the correct version. Will add TAP tests to src/test/modules/test_pg_dump Regards, -- Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Commits
-
Rethink recent fix for pg_dump's handling of extension config tables.
- 710c0a66d6e9 9.6.20 landed
- 0bfe356c5594 9.5.24 landed
- f2c6e94f0790 11.10 landed
- 0c79dcb36c52 10.15 landed
- d8c2a2199867 12.5 landed
- 2ea624b4b51c 13.1 landed
- 9e5f1f21ad6a 14.0 landed