Hi, 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. I tried working around this by using asynchronous queries and $sth->pg_cancel(), but it had some strange affects (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, is it a difficult endeavor? -- Eric Simon The IQ Group, Inc.
