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.