Re: Interrupting Cursors - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Interrupting Cursors
Date
Msg-id 20060522175541.GA11117@winnie.fuhr.org
Whole thread Raw
In response to Re: Interrupting Cursors  (Steve Tucknott <steve@retsol.co.uk>)
Responses Re: Interrupting Cursors
List pgsql-novice
On Mon, May 22, 2006 at 06:47:20PM +0100, Steve Tucknott wrote:
> Looks as though it may well do. I'll see if I can get the pid of the
> process and give it a go.

"SELECT * FROM pg_stat_activity" might be useful for obtaining the
pid, especially if you have stats_command_string enabled.  On
Unix-like systems the output from "ps" might also be helpful.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Steve Tucknott
Date:
Subject: Re: Interrupting Cursors
Next
From: Steve Tucknott
Date:
Subject: Re: Interrupting Cursors