Sent: Monday, August 23, 2010 7:06 PM
To: Eric Simon
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Problem Using PQcancel in a Synchronous Query
Eric Simon esi...@theiqgroup.com writes:
Now that I've established some context, here's where I'm at: I've written
$sth-cancel() for DBD::Pg
Hi,
I am using Perl (DBD::Pg) with Postgres. DBD::Pg already fully supports
asynchronous queries, and the canceling of those queries, but I need to
cancel a synchronous query. So to do that, I am trying to write
$sth-cancel() support for DBD::Pg. Here's my example in Perl:
my $aborted
Eric Simon esi...@theiqgroup.com writes:
Now that I've established some context, here's where I'm at: I've written
$sth-cancel() for DBD::Pg using PQcancel(), and it works (it returns the
status 57014: QUERY CANCELED). The problem is that the $sth-execute call
(which resides between the two