public inbox for [email protected]
help / color / mirror / Atom feedFrom: raf <[email protected]>
To: [email protected]
Subject: Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors
Date: Wed, 4 Sep 2024 12:39:28 +1000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CAKFQuwZsJ+oGEiyxFLppF7c-JU5=00u0pwZdqjqrnV94uL6oUA@mail.gmail.com>
<[email protected]>
<[email protected]>
On Tue, Sep 03, 2024 at 10:28:44PM -0400, Tom Lane <[email protected]> wrote:
> raf <[email protected]> writes:
> > On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston" <[email protected]> wrote:
> >> You specified “-1” so I don’t get why you believe pg_restore should be
> >> continuing to execute in the face of the SQL error.
>
> > The reason I believe pg_restore should be continuing to execute in the face of
> > the SQL error is because I didn't supply the -e option which is described
> > thusly in the pg_restore manual entry:
>
> But you'd better also read the para about -1:
>
> -1
> --single-transaction
> Execute the restore as a single transaction (that is, wrap the
> emitted commands in BEGIN/COMMIT). This ensures that either all
> the commands complete successfully, or no changes are
> applied. This option implies --exit-on-error.
>
> regards, tom lane
>
Yes, I saw that. Many thanks. All good now.
cheer,
raf
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox