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
http://www.postgresql.org/docs/7.4/interactive/protocol-flow.html#AEN52769 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).
/Nis
