Re: psql terminates on first error

[Holger Jakobs <holger@xxxxxxxxxx>]

Am 02.03.23 um 13:48 schrieb Thomas Kellerer:
> 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.
Whether I use pipes or writing stdout of pg_dumpall to a file and 
reading back with psql from the file made no difference.

--

Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Attachment: OpenPGP_signature
Description: OpenPGP digital signature