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