Description:
------------
"ON INSERT" rule on view returns rows which cannot be retrieved by PDO::fetchAll():

We have a view that has a ON INSERT DO INSTEAD rule. In this rule the insert on the view is basically split to do the actual inserts into the individual tables. In the end it SELECTs the new row (which has just been created) from that view. Doing this in psql for example behaves like expected: after the INSERT  the new row is returned.

We haven't managed to retrieve that row into an array via "PDO::fetchAll(PDO::FETCH_ASSOC)" - for some reason PDO seems to ignore that returned data - though PDO::rowCount returns 1 (actually it does always return 1 no matter how many rows are expected to be returned by that INSERT).

This scenario works as expected when connected via PHP's pg_connect using pg_fetch_all.


Information from phpinfo():

pdo_pgsql
PDO Driver for PostgreSQL	enabled
PostgreSQL(libpq) Version 	8.3.7
Module version 	1.0.2
Revision 	$Id: pdo_pgsql.c,v 1.7.2.11.2.2 2007/12/31 07:20:10 sebastian Exp $ 


Reproduce code:
---------------
For a small schema setup run this file through psql:
http://www.byoc.de/pdo-pgsql.sql.txt

This script inserts to the created example view and tries to retrieve the values:
http://www.byoc.de/pdo-pgsql.php.txt

Expected result:
----------------
the associative array should contain all rows returned by the INSERT statement.

Actual result:
--------------
an empty array is returned by PDO::fetchAll though there are rows returned.