Re: psql terminates on first error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux