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@momjian.us EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +