Perl DBI::Pg - Stop button

Hello again,

I have searched around for an answer to this for a while but not found
a completely convincing one...

Whats the best way to terminate a query when the user presses the stop
button?

I know that apache only discovers that the client has gone when it
tries to send data back - will this require some child process to send
data to the client  while a query is being performed?

I am hoping theres an existing tried and tested solution?!

Thanks,

Matt