|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-06-28 18:36 UTC] edink at emini dot dk
[2005-06-29 09:57 UTC] bjori at jeshus dot com
[2021-10-30 05:48 UTC] usgfjgdddds at gmail dot com
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 08 05:00:02 2025 UTC |
Description: ------------ (running PHP5.0.4, not .3) PDO 0.3 PDO_PGSQL 0.2 select nextval() *always* returns NULL Reproduce code: --------------- <?php $PDO = new PDO(...); $PDO->setAttribute(PDO_ATTR_CASE, PDO_CASE_UPPER); $sql = "CREATE TABLE foo(id serial not null primary key)"; $PDO->exec($sql); $sql = "INSERT INTO foo VALUES(1);"; $PDO->exec($sql); $sql = "SELECT nextval('foo_id_seq')"; $PDOStatement = $PDO->prepare($sql); $PDOStatement->execute(); $PDOStatement->bindColumn("NEXTVAL", $id); $row = $PDOStatement->fetchAll(); var_dump($id, $row, $PDO->errorInfo(), $PDOStatement->errorInfo()); $sql = "DROP TABLE foo"; $PDO->exec($sql); ?> Expected result: ---------------- 2 array(1) { [0]=> array(2) { ["NEXTVAL"]=> 2 [0]=> 2 } } array(1) { [0]=> string(5) "00000" } array(1) { [0]=> string(5) "00000" } Actual result: -------------- NULL array(1) { [0]=> array(2) { ["NEXTVAL"]=> NULL [0]=> NULL } } array(1) { [0]=> string(5) "00000" } array(1) { [0]=> string(5) "00000" }