Re: Interrupting Cursors

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
Cc: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Interrupting Cursors
Date: 2006-05-22 17:55:41
Message-ID: 20060522175541.GA11117@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Tucknott 2006-05-22 18:10:39 Re: Interrupting Cursors
Previous Message Steve Tucknott 2006-05-22 17:47:20 Re: Interrupting Cursors