Re: [Proposal] Allow pg_dump to include all child tables with the root table - Mailing list pgsql-hackers

From Stéphane Tachoires
Subject Re: [Proposal] Allow pg_dump to include all child tables with the root table
Date
Msg-id CA+gpmfKgujFY6zLddhpoa8RYVrQo4ptcHAPdijvRg0O2-Brhfw@mail.gmail.com
Whole thread Raw
In response to Re: [Proposal] Allow pg_dump to include all child tables with the root table  (Gilles Darold <gilles@migops.com>)
Responses Re: [Proposal] Allow pg_dump to include all child tables with the root table  (Gilles Darold <gilles@migops.com>)
List pgsql-hackers

Hi Gilles,

On Ubuntu 22.04.2 all deb's updated, I have an error on a test
I'll try to find where and why, but I think you should know first.

1/1 postgresql:pg_dump / pg_dump/002_pg_dump        ERROR            24.40s   exit status 1
―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― ✀  ――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――
stderr:
#   Failed test 'only_dump_measurement: should dump CREATE TABLE test_compression'
#   at /media/hddisk/stephane/postgresql/src/postgresql/src/bin/pg_dump/t/002_pg_dump.pl line 4729.
# Review only_dump_measurement results in /media/hddisk/stephane/postgresql/build/testrun/pg_dump/002_pg_dump/data/tmp_test_iJxJ
# Looks like you failed 1 test of 10264.

(test program exited with status code 1)
――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――


Summary of Failures:

1/1 postgresql:pg_dump / pg_dump/002_pg_dump ERROR            24.40s   exit status 1


Ok:                 0  
Expected Fail:      0  
Fail:               1  
Unexpected Pass:    0  
Skipped:            0  
Timeout:            0  

Join, only_dump_measurement.sql from /media/hddisk/stephane/postgresql/build/testrun/pg_dump/002_pg_dump/data/tmp_test_iJxJ
If you need more information, please ask...

Stéphane.


Le dim. 12 mars 2023 à 10:04, Gilles Darold <gilles@migops.com> a écrit :
Le 11/03/2023 à 19:51, Gilles Darold a écrit :
> Le 04/03/2023 à 20:18, Tom Lane a écrit :
>> As noted, "childs" is bad English and "partitions" is flat out wrong
>> (unless you change it to recurse only to partitions, which doesn't
>> seem like a better definition).  We could go with
>> --[exclude-]table-and-children, or maybe
>> --[exclude-]table-and-child-tables, but those are getting into
>> carpal-tunnel-syndrome-inducing territory 🙁.  I lack a better
>> naming suggestion offhand.
>
>
> In attachment is version 3 of the patch, it includes the use of
> options suggested by Stephane and Tom:
>
>     --table-and-children,
>
>     --exclude-table-and-children
>
>     --exclude-table-data-and-children.
>
>  Documentation have been updated too.
>
>
> Thanks
>

New version v4 of the patch attached with a typo in documentation fixed.

--
Gilles Darold.


--
"Où se posaient les hirondelles avant l'invention du téléphone ?"
  -- Grégoire Lacroix
Attachment

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Improve WALRead() to suck data directly from WAL buffers when possible
Next
From: Tomas Vondra
Date:
Subject: Re: Add LZ4 compression in pg_dump