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.

-- 
  Richard Huxton
  Archonet Ltd

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to