Re: psql exit code

On Mon, 10 Nov 2008 10:56:57 +0000
Richard Huxton <dev@archonet.com> wrote:

> Ivan Sergio Borgonovo wrote:
> > I'm running:
> >
> > ON_ERROR_STOP="on" PGPASSFILE="/somewhere" psql dbname username
> > -f script.sql
> > (or alternatively <script.sql)
> >
> > echo $?
> > always returns 0 even when sql is clearly wrong.
>
> I don't think ON_ERROR_STOP is read from the environment, you need
> to define it as a psql variable.
>
> psql -v 'ON_ERROR_STOP=on' ...
>
> That should give you an error code.

Thanks. You're right.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it