Forum OpenACS Development: Re: Problem with db_transaction?

Posted by Nis Jørgensen on
I certainly wouldn't be sending any (OS) signals to the db server when shutting down AOLServer. However I would expect the database driver to terminate it's connections to the dbms, which I would in turn expect to cause the running queries to terminate (like pressing Ctrl-C in a psql terminal).

From reading the docs here about cancellation and termination , it seems the problem is that postgres only checks for termination (normal or abnormal) BETWEEN queries.

Since this should normally not be happening, I do not think the behaviour is unreasonable. A cancellation interface could come in handy in other cases though (such as the ability to kill long running queries).