Re: psql terminates on first error - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: psql terminates on first error
Date
Msg-id 1b41a19f-5672-e185-f3ec-df96c6dcbae7@gmx.net
Whole thread Raw
In response to Re: psql terminates on first error  (Holger Jakobs <holger@jakobs.com>)
Responses Re: psql terminates on first error  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Holger Jakobs schrieb am 02.03.2023 um 13:44:
>>> Only when using an option -c "\set ON_ERROR_STOP false" (plus -f - of
>>> course to continue reading) psql continued after first error.
>> Do you use PowerShell and pipe pg_dumpall into psql?  The first thing that
>> comes to my mind when reading Postgres+Windows is that PowerShell up to
>> version 5.1 converts stdout to UTF-16LE.  This already tripped me up in
>> past with pg_dump and psql.
> No, it was in cmd.exe or in bash

I find using pipes with the Postgres command line tools on Windows unreliable
in general (including cmd.exe). So if you did use redirection/pips, try without.





pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: psql terminates on first error
Next
From: Holger Jakobs
Date:
Subject: Re: psql terminates on first error