2009/9/16 Tom Lane <t...@sss.pgh.pa.us>: > =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryz...@gmail.com> writes: >> Looks like psql loves to report on errors, only when -c is used, >> otherwise return code is always 0... > > The documentation seems perfectly clear on this point: > > psql returns 0 to the shell if it finished normally, 1 if a fatal error of > its own (out of memory, file not found) occurs, 2 if the connection to the > server went bad and the session was not interactive, and 3 if an error > occurred in a script and the variable ON_ERROR_STOP was set.
Well, but what you are looking for from - say - script, that calls psql to perform single action - is a meaningful exit code. That would specify whether SQL code returned any errors or not. This clearly shows, that you can rely only on -c, but others - appear to be inconsistent. (behave different, depending on how you feed the input to psql). -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
