Обсуждение: BUG #1556: psql ON_ERROR_STOP returns 3 when scripts ends in C style comment

Поиск
Список
Период
Сортировка

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

От
"Dennis van Dok"
Дата:
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

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

От
Tom Lane
Дата:
"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