Re: [HACKERS] Problem Using PQcancel in a Synchronous Query

2010-08-24 Thread Eric Simon
Lane 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" writes: > Now that I've established some context, here's where I'm at: I've written >

Re: [HACKERS] Problem Using PQcancel in a Synchronous Query

2010-08-23 Thread Tom Lane
"Eric Simon" 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 alarm() calls a

[HACKERS] Problem Using PQcancel in a Synchronous Query

2010-08-23 Thread Eric Simon
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