From: Tom Lane <tgl@sss.pgh.pa.us>
To: raf <postgres@raf.org>
cc: pgsql-general@lists.postgresql.org
Subject: Re: Help with "gpg -d ... | pg_restore ..." with unimportant pg_restore errors
In-reply-to: <ZtfEsfn1HaxQyy2x@raf.org>
References: <Zte4r3rQ9_GbCZe-@raf.org> <CAKFQuwZsJ+oGEiyxFLppF7c-JU5=00u0pwZdqjqrnV94uL6oUA@mail.gmail.com> <ZtfEsfn1HaxQyy2x@raf.org>
Comments: In-reply-to raf <postgres@raf.org>
	message dated "Wed, 04 Sep 2024 12:23:45 +1000"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1543229.1725416924.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 03 Sep 2024 22:28:44 -0400
Message-ID: <1543230.1725416924@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1543230.1725416924%40sss.pgh.pa.us>
Precedence: bulk

raf <postgres@raf.org> writes:
> On Tue, Sep 03, 2024 at 06:43:22PM -0700, "David G. Johnston" <david.g.j=
ohnston@gmail.com> wrote:
>> You specified =E2=80=9C-1=E2=80=9D so I don=E2=80=99t get why you belie=
ve 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 f=
ace of
> the SQL error is because I didn't supply the -e option which is describe=
d
> 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