[2007-09-27 19:38 UTC] maciej-php at killer-robot dot net

Description:
------------
pg_insert() does not accept empty lists of values. Empty lists of values can be useful for tables with defaults set on columns. Postgres provides a construct for inserting an empty list: "INSERT INTO foo DEFAULT VALUES".

Reproduce code:
---------------
pg_query($conn, 'CREATE TABLE foo (id SERIAL PRIMARY KEY, time TIMESTAMP NOT NULL DEFAULT now())');
var_dump( pg_insert($conn, 'foo', array('time' => '2007-08-08 1:30:00'), PGSQL_DML_STRING));
var_dump( pg_insert($conn, 'foo', array(), PGSQL_DML_STRING));


Expected result:
----------------
string(53) "INSERT INTO foo (time) VALUES ('2007-08-08 1:30:00');"
string(30) "INSERT INTO foo DEFAULT VALUES"

Actual result:
--------------
string(53) "INSERT INTO foo (time) VALUES ('2007-08-08 1:30:00');"
bool(false)

 [2007-10-03 23:32 UTC] iliaa@php.net

This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.