Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Killing process in postgresql does not work

bherila's profile image bherila posted 3 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.

bherila's profile image bherila posted 3 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 3 years ago Permalink

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

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
bherila's profile image bherila posted 3 years ago Permalink

Awesome thanks :)

Code modification/commit aa373aa from ansgarbecker, 3 years ago, revision 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 3 years ago Permalink

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

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