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