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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general