Killing process in postgresql does not work

bherila posted 2 years ago in Feature discussion

When we want to kill a process in postgresql, we are currently using a command like:

KILL 34008;

However the right way to do this in postgresql is actually :

select pg_cancel_backend(34008);

This should be a simple fix but I don't have a Delphi setup to do a PR.

bherila posted 1 year ago

Any update on this? I had hoped it would be a very simple change.

Thanks, Ben

ansgar posted 1 year ago

Yes, indeed. I will see if I get this into the code soon.

bherila posted 1 year ago

Awesome thanks :)

ansgar posted 1 year ago

r5129 should use the right SQL query for killing a process.

Please login to leave a reply, or register at first.