Re: psql return codes

Simon Riggs wrote:
> Currently, if we issue this command
> 
>     psql --set ON_ERROR_STOP= -f f.sql
> 
> where f.sql has "select * from foo;"
> then psql will return 
> 0    if foo exists
> 3    if foo does not exist (or other SQL error)
> 
> Whereas
>     psql --set ON_ERROR_STOP= -c "select * from foo;"
> returns
> 0    if foo exists
> 1    if foo does not exist (or other SQL error)
> 
> Is this a minor oversight, or some aspect of design?

Well, our psql manual page has:
EXIT STATUS       psql  returns 0 to the shell if it finished normally, 1 if       a fatal error of its own (out of
memory,file  not  found)       occurs, 2 if the connection to the server went bad and the       session was not
interactive,and 3 if an error occurred in       a script and the variable ON_ERROR_STOP was set.
 

Were you asking if this behavior is documented, or if it is desirable?

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +