Re: pg_restore documentation and --create/--single-transaction limitation

From: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore documentation and --create/--single-transaction limitation
Date: 2025-04-02 11:16:30
Message-ID: CAExHW5sT7X_wMsn=hNpAR31vrzxXcmhfGDkHJw1Ks42M_JvEnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Mar 24, 2025 at 5:11 PM Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> Hi All,
> The pg_restore documentation usually mentions the pair of switches
> which can not be used together. However, it does not mention that
> --create and --single-transaction can not be used together. Here's a
> patch fixing the same.
>
> Looking for a precedence, I found that we have mentioned a similar
> limitation concerning --data-only and --schema-only only under
> --schema and not at both the sections. Maybe it's missing or we chose
> to mention it only at one place. But then I am not sure which one
> place I should use to mention the new limitation. So, I have added the
> note in the sections corresponding to both the switches so that a user
> reading either of them knows about the limitation.

Adding this to the next CF to get some attention. It will be good to
ship this doc fix with the PG 18 release though.

--
Best Wishes,
Ashutosh Bapat

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ranier Vilela 2025-04-02 11:28:02 Small optimization set tuple block/tableOid once
Previous Message Bertrand Drouvot 2025-04-02 11:14:52 Re: Fix 035_standby_logical_decoding.pl race conditions