On Mon, 10 Nov 2008 10:56:57 +0000 Richard Huxton <dev@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
