From: php at benjaminschulz dot com Operating system: osx PHP version: 5.3CVS-2008-04-29 (CVS) PHP Bug Type: PDO related Bug description: scrollable cursor don't work with pgsql
Description: ------------ I don't see how to use scrollable cursors with pdo_pgsql Reproduce code: --------------- $db = new Pdo("pgsql:..."); $db->setAttribute(Pdo::ATTR_ERRMODE, Pdo::ERRMODE_EXCEPTION); $res = $db->prepare("SELECT 'row1' UNION SELECT 'row2' UNION SELECT 'row3' UNION SELECT 'row4'", array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL)); $res->execute(); var_dump($res->fetch()); // $res->fetch(Pdo::FETCH_NUM, PDO::FETCH_ORI_ABS, 2) won't throw an exception but return false Expected result: ---------------- array('row1') Actual result: -------------- Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[34000]: Invalid cursor name: 7 ERROR: cursor "pdo_pgsql_cursor_00d78a0c" does not exist' in ... -- Edit bug report at http://bugs.php.net/?id=44861&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=44861&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=44861&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=44861&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=44861&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=44861&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=44861&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=44861&r=needscript Try newer version: http://bugs.php.net/fix.php?id=44861&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=44861&r=support Expected behavior: http://bugs.php.net/fix.php?id=44861&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=44861&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=44861&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=44861&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44861&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=44861&r=dst IIS Stability: http://bugs.php.net/fix.php?id=44861&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=44861&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=44861&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=44861&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=44861&r=mysqlcfg