On 12/19/2011 01:04 PM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
This feature is close to commit as a new one for PostgreSQL 9.2:
http://archives.postgresql.org/message-id/4eeb3a2b.8090...@2ndquadrant.com
http://archives.postg
On 12/19/2011 07:46 PM, Craig James wrote:
> Backend Postgres processes run as the Postgres user, so they have
> permission to kill each other. You write an add-on function that just
> kills a process:
>
> select my_kill_backend(pid);
>
> Naturally, this is very dangerous. There are all sorts
On 12/19/11 10:04 AM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on
