Re: How to terminate a query

From: A B <gentosaker(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to terminate a query
Date: 2010-04-21 05:59:15
Message-ID: g2udbbf25901004202259hc0f3dbd4w106820bce710b26b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-04-21 05:59:29 Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)
Previous Message Yan Cheng CHEOK 2010-04-21 05:47:49 Re: unable to start postgresql server services (Windows XP/Professional/Service Pack3)