Re: sigint psql

Doug McNaught wrote:
> John DeSoi <desoi(at)pgedit(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073