php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37037 pgsql: Can't access result returned from an INSERT
Submitted: 2006-04-11 10:30 UTC Modified: 2006-12-30 02:34 UTC
From: shadda at gmail dot com Assigned:
Status: Wont fix Package: PDO related
PHP Version: 5.1.3RC2 OS: Debian 3.1
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
18 + 2 = ?
Subscribe to this entry?

 
 [2006-04-11 10:30 UTC] shadda at gmail dot com
Description:
------------
I'm using PostgreSQL 8.1.2, on Debian Sid. In my database, I have a table with a RULE on inserts...

CREATE RULE test_rule AS 
   ON INSERT TO test_table
   DO ALSO
     SELECT NEW.id;

When a new row is inserted to this table, it returns the ID (currval) of the new row. This works from PSQL, DBI (perl), and JDBC, aswell as the standard Pgsql extension in PHP.

From PDO, however, when calling PDOStatement::Fetch() after an insert, only an empty array is returned, and not the resultset I was expecting.

Reproduce code:
---------------
create table test_table ( id serial primary key );
create rule test_rule as on insert to test_table do also select new.id;

postgres@Xanadu:/$ php -r '
$db = new PDO("pgsql:host=localhost;user=xoom;password=1914;dbname=general");
$q = $db->query("insert into foo default values");
var_dump($q->fetch());
'


Expected result:
----------------
array(2) {
  [0]=>
  string(2) "10"
  ["id"]=>
  string(2) "10"
}

Actual result:
--------------
array(0) {
}

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-04-11 10:36 UTC] shadda at gmail dot com
Just a quick note -- in the above insert statement, the table should be 'test_table'
 [2006-05-01 01:08 UTC] wez@php.net
The issue related to native prepared statements not describing that magical result set.

Workaround:

$stmt = $db->prepare("insert into test_table default values", array(
    PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT => true));
$stmt->execute();
print_r($stmt->fetchAll());


 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Sat Jul 20 01:01:25 2019 UTC