Re: psql return codes

Jim C. Nasby wrote:
> > 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?
>
> Maybe I'm just dense this AM, but I'm not seeing how that explains what
> Simon is seeing? Why should it matter if the "SELECT * FROM foo" came to
> psql via -f or -c?

Well, it explains exactly what Simon was seeing. I agree it is strange,
but I was asking if Simon knew it was documented. I assume the "3" is
used to report a different error from 'file not found' or something.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +