Re: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)

2022-01-16 Thread Julien Rouhaud
Hi, On Mon, Dec 27, 2021 at 12:31:07PM -0500, Tom Lane wrote: > Justin Pryzby writes: > > I think the current behavior of the regression test SQL scripts is exactly > > the > > opposite of what's desirable for almost all other scripts. The attached > > makes > > ON_ERROR_STOP the default, and

Re: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)

2021-12-27 Thread Tom Lane
Justin Pryzby writes: > I think the current behavior of the regression test SQL scripts is exactly the > opposite of what's desirable for almost all other scripts. The attached makes > ON_ERROR_STOP the default, and runs the regression tests with ON_ERROR_STOP=0. > Is it viable to consider chang

Re: default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)

2021-12-27 Thread Pavel Stehule
po 27. 12. 2021 v 17:10 odesílatel Justin Pryzby napsal: > On Mon, Dec 06, 2021 at 09:08:56AM -0600, Justin Pryzby wrote: > > I raised this issue a few years ago. > > > https://www.postgresql.org/message-id/20181217175841.GS13019%40telsasoft.com > > > > |[pryzbyj@database ~]$ psql -v VERBOSITY=te

default to to ON_ERROR_STOP=on (Re: psql: exit status with multiple -c and -f)

2021-12-27 Thread Justin Pryzby
On Mon, Dec 06, 2021 at 09:08:56AM -0600, Justin Pryzby wrote: > I raised this issue a few years ago. > https://www.postgresql.org/message-id/20181217175841.GS13019%40telsasoft.com > > |[pryzbyj@database ~]$ psql -v VERBOSITY=terse ts -xtc 'ONE' -c "SELECT > 'TWO'"; echo "exit status $?" > |ERROR

psql: exit status with multiple -c and -f

2021-12-06 Thread Justin Pryzby
I raised this issue a few years ago. https://www.postgresql.org/message-id/20181217175841.GS13019%40telsasoft.com |[pryzbyj@database ~]$ psql -v VERBOSITY=terse ts -xtc 'ONE' -c "SELECT 'TWO'"; echo "exit status $?" |ERROR: syntax error at or near "ONE" at character 1 |?column? | TWO | |exit sta