On Mon, Dec 6, 2010 at 1:46 PM, bricklen <bricklen(at)gmail(dot)com> wrote:
> On Sat, Dec 4, 2010 at 11:45 AM, felix <crucialfelix(at)gmail(dot)com> wrote:
>> Ok, I caught one : an update that is stuck in waiting.
>> the first one blocks the second one.
>> ns | 5902 | nssql | UPDATE "fastadder_fastadderstatus" SET "built"
>> = false WHERE "fastadder_fastadderstatus"."service_id" = 1
>
> Not sure if anyone replied about killing your query, but you can do it like so:
>
> select pg_cancel_backend(5902); -- assuming 5902 is the pid of the
> query you want canceled.
How does this differ from just killing the pid?
--
Jon