Postgres Pro
Downloads
Home   >   mailing lists

Cancel a query. - Mailing list pgsql-general

From Rob Brown-Bayliss
Subject Cancel a query.
Date
Msg-id AANLkTimfAah_TDMLfcOJ2R0T1FmUhb43f0tf3R8Zkhn=@mail.gmail.com
Whole thread Raw
Responses Re: Cancel a query.  (Vick Khera <vivek@khera.org>)
Re: Cancel a query.  (Matthieu Huin <matthieu.huin@wallix.com>)
List pgsql-general
Tree view 
Hi

I have some code using psycopg in python.  Connecting in async mode.

I am trying to catch time outs etc, basically after a set amount of
time I am assuming something has failed.

I then want to use "select pg_cancel_backend(15209);" to cancel the
query.  But I can't unless I am connected as the postgres super user.

How can I get my app to cancel one of it's own queries while logged on
as a normal user?



Thanks.

--

Rob

pgsql-general by date:

Previous
From: Elliot Chance
Date:
Subject: Fwd: The first dedicated PostgreSQL forum
Next
From: Kent Tong
Date:
Subject: shared data for different applications