Re: sigint psql - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: sigint psql
Date
Msg-id 200502211739.j1LHd9S15675@candle.pha.pa.us
Whole thread Raw
In response to Re: sigint psql  (Doug McNaught <doug@mcnaught.org>)
List pgsql-hackers
Doug McNaught wrote:
> John DeSoi <desoi@pgedit.com> writes:
> 
> > I'm communicating with psql via a pipe stream. This works pretty well,
> > but one problem I have is trying to cancel an operation. If I send a
> > sigint, psql dies. In looking at the source I gather this is because
> > it assumes I'm in non-interactive mode (pset.notty is true). I was
> > wondering if there was some way to work around this short of
> > recompiling the source. I need to do the same thing on Windows.
> >
> > Thanks for any suggestions,
> 
> On Unix you could run 'psql' through a pty rather than a pipe.  No
> idea what the Windows equivalent would be.

We don't have signals on win32 like we have on Unix so we simulate them.
Not sure it is possible to signal psql like you want on Win32.

I just tried 'kill -2 _psql_pid_' on unix and it did cancel the current
query.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: Re: Query optimizer 8.0.1 (and 8.0)
Next
From: Bruce Momjian
Date:
Subject: Re: Data loss, vacuum, transaction wrap-around