Killing process in postgresql does not work

[expired user #9707]'s profile image [expired user #9707] posted 8 years ago in Feature discussion Permalink

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.

[expired user #9707]'s profile image [expired user #9707] posted 8 years ago Permalink

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

Thanks, Ben

ansgar's profile image ansgar posted 8 years ago Permalink

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

[expired user #9707]'s profile image [expired user #9707] posted 8 years ago Permalink

Awesome thanks :)

Code modification/commit aa373aa from ansgarbecker, 8 years ago, revision 9.4.0.5129
Use the right SQL commands for killing a process on PostgreSQL. See http://www.heidisql.com/forum.php?t=21760
ansgar's profile image ansgar posted 8 years ago Permalink

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

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