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,


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

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, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly