From: f dot engelhardt at 21torr dot com Operating system: Linux PHP version: 5CVS-2005-11-22 (CVS) PHP Bug Type: PDO related Bug description: PDO freezes while retreiving binary data from postgres
Description: ------------ I tried to write binary data into a postgresql table, that work, but i can not get this data out the table anymore. Reproduce code: --------------- <?php $dbh = new PDO('pgsql:host=localhost;dbname=test','root','fo0224'); $q = 'SELECT data FROM foobar'; $stmt = $dbh->prepare($q); if ($stmt) { $stmt->bindColumn('DATA',$sData); if (!$stmt->execute()) { print_r($stmt->errorInfo()); die('DAMN'); } if (!$stmt->fetch(PDO::FETCH_BOUND)) { print_r($stmt->errorInfo()); die('DAMN'); } header('Content-Type: image/jpeg'); echo $sData; } else { print_r($dbh->errorInfo()); } ?> Table foobar only has a bytea column named data Expected result: ---------------- should display the image Actual result: -------------- the php-process does not do anything, the browser waits for an answer (i waited 5 minutes, but nothing happened) -- Edit bug report at http://bugs.php.net/?id=35338&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35338&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35338&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35338&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35338&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35338&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35338&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35338&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35338&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35338&r=support Expected behavior: http://bugs.php.net/fix.php?id=35338&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35338&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35338&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35338&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35338&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35338&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35338&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35338&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35338&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35338&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35338&r=mysqlcfg