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) {
}