Solaris - psql returns 0 instead of 1 for file not found.

From: "Clark, Andrew" <Andrew(dot)Clark(at)fnf(dot)com>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: Solaris - psql returns 0 instead of 1 for file not found.
Date: 2005-09-19 18:01:03
Message-ID: 74825F195D477C4995425A1313D646B114A923@smbfisyyz01.FNFIS.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches pgsql-ports

Hi all,

I've found the when psql is used with the -f flag and the specified file
doesn't exist the rc value is 0.

$ uname -a
SunOS bld 5.8 Generic_108528-29 sun4u sparc SUNW,Sun-Fire-V440

$ psql -V
psql (PostgreSQL) 8.0.2

$ ls foo
foo: No such file or directory

$ psql -f foo
foo: No such file or directory

$ echo $?
0

However, in the man page for psql it says:

EXIT STATUS
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, ...

I'm assuming this is the same with other platforms, but I only use
PostgreSQL on Solaris.

Has this been fix in 8.0.3?

Cheers,
Andrew

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Wade Hampton 2005-09-19 18:18:55 BUG #1897: dmalloc memory error on PQconnectdb
Previous Message Tom Lane 2005-09-19 15:25:19 Re: BUG #1893: pg_dumpall - Search path order

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-09-19 20:33:27 Re: [PATCH] Add support for IS NULL to btree indexes
Previous Message Martijn van Oosterhout 2005-09-19 17:51:07 [PATCH] Add support for IS NULL to btree indexes

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 2005-09-20 19:00:56 Re: [PORTS] Solaris - psql returns 0 instead of 1 for file not found.
Previous Message Merlin Moncure 2005-09-19 15:24:59 Re: could help me?