DBD::Pg Implementation for cancel()?

Hi,

We're using Postgres, and we utilize a sessions table in our web app that
requires us to do a 'SELECT FOR UPDATE', which means that a second process
could block if it also calls 'SELECT FOR UPDATE'.  In order to armor against
users clogging up the system, we need to be able to call $sth->cancel() if
Postgres can't respond within 30 seconds.

However, cancel() is not implemented in DBD::Pg.  I tried working around
this by using the available asynchronous query mechanism and
$sth->pg_cancel(), but it had some destabilizing effects (and I did ensure
that I called rollback() after pg_cancel())...sorry for the vagueness here).
Since we don't need asynchronous code if cancel() was implemented, then I'm
hoping to avoid it as it just creates more probability for error.

Is there any plan to implement cancel()?  If not, would it be a difficult
endeavor for an average C programmer to tackle?

-- 
Eric Simon
The IQ Group, Inc.