Skip site navigation (1) Skip section navigation (2)

Re: BUG #3059: psql to 'postgres' shortcut

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Raymond Naseef <raymondnaseef(at)yahoo(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3059: psql to 'postgres' shortcut
Date: 2007-02-27 13:28:48
Message-ID: 20070227132848.GQ12721@svr2.hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Feb 26, 2007 at 09:46:24AM -0500, Bruce Momjian wrote:
> Raymond Naseef wrote:
> > 
> > The following bug has been logged online:
> > 
> > Bug reference:      3059
> > Logged by:          Raymond Naseef
> > Email address:      raymondnaseef(at)yahoo(dot)com
> > PostgreSQL version: 8.2
> > Operating system:   Windows XP
> > Description:        psql to 'postgres' shortcut
> > Details: 
> > 
> > The shortcut to run psql.exe added to the menus is a great think to do, but
> > when the program stops the window closes with no pause or time delay.
> > 
> > This is a serious issue if the login fails.  Sometimes I forget to start the
> > server, but I do not know that because I cannot read text in ~0.02 seconds.
> > 
> > BTW, I bet some of your other .bat files have the same issue.
> > 
> > Please run it by doing 1 or other:
> > 1. Putting a "pause" at the end of the batch file.
> > 2. cmd.exe /K "<command line>"
> >     (just note the "" for default user name will make this fail.  Sorry I do
> > not know how to fix that unless username has no bad-for-cmd characters in
> > it, then quotes are not needed)
> > 
> 
> These solutions are going to make psql very annoying when it does work
> properly.

Indeed. But it *is* also a problem the way it is now (I've noticed
myself a couple of times, but never had the time to fix it)

Perhaps a reasonable thing to do would be to have the shortcut point to
a .BAT file that does a "pause" only if psql exits with a non-zero
exitcode.

Is this reasonable? Will psql always exit with non-zero when something
like this happen and also importantly, willi t always exit with a zero
exitcode if there is no problem? 

//Magnus

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2007-02-27 13:40:11
Subject: Re: Spelling error in 8.1.6-1 Windows Error Dialog typo
Previous:From: Zdenek KotalaDate: 2007-02-27 12:42:24
Subject: Re: [PATCHES] BUG #2969: Inaccuracies in Solaris FAQ

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group