Cancel a query.

Поиск
Список
Период
Сортировка
От Rob Brown-Bayliss
Тема Cancel a query.
Дата
Msg-id AANLkTimfAah_TDMLfcOJ2R0T1FmUhb43f0tf3R8Zkhn=@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cancel a query.  (Vick Khera <vivek@khera.org>)
Re: Cancel a query.  (Matthieu Huin <matthieu.huin@wallix.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Elliot Chance
Дата:
Сообщение: Fwd: The first dedicated PostgreSQL forum
Следующее
От: Kent Tong
Дата:
Сообщение: shared data for different applications