Skip site navigation (1) Skip section navigation (2)

Re: Interrupting Cursors

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Interrupting Cursors
Date: 2006-05-22 18:10:39
Message-ID: 1148321439.3360.57.camel@vrsol.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
Michael,
Thanks for the pointers - we use Linux so I had thought of just using ps
- but I'll also look into the pg_stat_activity table and see what's in
that ... 

Thanks again.

On Mon, 2006-05-22 at 11:55 -0600, Michael Fuhr wrote:

> 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.
> 

Regards,

Steve Tucknott
ReTSol Ltd

DDI: 01903 828769
Mobile: 0773 671 5772

In response to

Responses

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-05-22 18:20:58
Subject: Re: Interrupting Cursors
Previous:From: Michael FuhrDate: 2006-05-22 17:55:41
Subject: Re: Interrupting Cursors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group