From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | borisnov(at)acm(dot)org |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_dump no-owner option |
Date: | 2021-01-13 17:54:20 |
Message-ID: | 1288537.1610560460@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> Currently the documentation reads:
> This option is only meaningful for the plain-text format.
> This statement is imprecise.
Yeah, I agree --- it's not clear whether the option is ignored or
rejected. Explicitly saying it's ignored is an improvement.
> Would be much better to change the behavior of the utility to allow the
> option for all formats, but htis is somewhat more than just documentaion
> change.
I disagree that that would be an improvement. Per the next sentence that
you omitted, the right time to apply this and similar options is when
extracting data from the archive format. (pg_dump to text effectively
constructs an archive dump in-memory and then extracts from that, so that
its "back half" logic is identical to pg_restore's.) Filtering this info
before dumping the archive would save no meaningful amount of space, while
restricting how the archive could be used later.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2021-01-13 21:22:10 | Truncate View |
Previous Message | Magnus Hagander | 2021-01-13 10:10:49 | Re: Typo |