BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment

Started by Dennis van Dokabout 21 years ago2 messagesbugs
Jump to latest
#1Dennis van Dok
dvandok@quicknet.nl

The following bug has been logged online:

Bug reference: 1556
Logged by: Dennis van Dok
Email address: dvandok@quicknet.nl
PostgreSQL version: 7.3.4
Operating system: Debian GNU/Linux 3.0
Description: psql ON_ERROR_STOP returns 3 when scripts ends in C
style comment
Details:

Running a script through psql with ON_ERROR_STOP=1 will yield return value 3
if the script ends with a C style comment (/*...*/).

minimal example:

echo '/**/' | psql -v ON_ERROR_STOP=1 template1; echo $?
3

:-/

Regards,

Dennis

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dennis van Dok (#1)
Re: BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment

"Dennis van Dok" <dvandok@quicknet.nl> writes:

PostgreSQL version: 7.3.4

Running a script through psql with ON_ERROR_STOP=1 will yield return value 3
if the script ends with a C style comment (/*...*/).

This seems to be fixed in 7.4.* and later.

regards, tom lane