Re: How to terminate a query - Mailing list pgsql-general

From A B
Subject Re: How to terminate a query
Date
Msg-id g2udbbf25901004202259hc0f3dbd4w106820bce710b26b@mail.gmail.com
Whole thread Raw
In response to Re: How to terminate a query  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: How to terminate a query  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-general
> select pg_cancel_backend(pid);
> will kill a running query.

Thanks.

> Sometimes cancel_backend fails because there's no point where the code
> checks for a cancel.

What would such a point in the code look like?

pgsql-general by date:

Previous
From: Yan Cheng CHEOK
Date:
Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)
Next
From: Scott Marlowe
Date:
Subject: Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)