Postgres Pro
Downloads
Home   >   mailing lists

Re: View running Processes ? - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: View running Processes ?
Date
Msg-id 20060224100517.GC20718@webserv.wug-glas.de
Whole thread Raw
In response to View running Processes ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: View running Processes ?
List pgsql-novice
Tree view 
am  24.02.2006, um 10:32:26 +0100 mailte Arnaud Lesauvage folgendes:
> Also, is there no way to kill a running query from *within*
> postgres ? With a query, or something similar ?

http://www.postgresql.org/docs/8.1/interactive/functions-admin.html
pg_cancel_backend(pid int)


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Re: View running Processes ?
Next
From: "Luis Silva"
Date:
Subject: Re: check problem