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

"Clark, Andrew" <[email protected]>
Newsgroups gmane.comp.db.postgresql.ports
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.