ID: 40198 Updated by: [EMAIL PROTECTED] Reported By: chores at jp1 dot cx -Status: Open +Status: Feedback Bug Type: PostgreSQL related Operating System: FreeBSD 6.2 PHP Version: 5.2.4 Assigned To: yohgaki New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi Really, try the snapshot.. Previous Comments: ------------------------------------------------------------------------ [2007-11-17 06:02:21] chores at jp1 dot cx non-fix v5.2.4 ------------------------------------------------------------------------ [2007-07-19 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2007-07-11 12:54:37] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi ------------------------------------------------------------------------ [2007-01-23 00:26:25] chores at jp1 dot cx Expected result (Correction): ----------------------------- INSERT INTO "t_test" ("c1","C2") VALUES ('0','0'); ------------------------------------------------------------------------ [2007-01-22 18:53:33] chores at jp1 dot cx Description: ------------ Column name is not double quoted % psql -U testuser testdb testdb=# CREATE TABLE t_test ("c1" char(10), "C2" char(10)); testdb=# \q % ./test.php INSERT INTO t_test (c1,C2) VALUES ('0','0'); % psql -U testuser testdb testdb=# INSERT INTO t_test (c1,C2) VALUES ('0','0'); ERROR: column "c2" of relation "t_test" does not exist Reproduce code: --------------- (test.php) #!/usr/local/bin/php <?php $db = pg_connect('dbname=testdb user=testuser'); $vals['c1'] = '0'; $vals['C2'] = '0'; echo pg_insert($db, 't_test', $vals, PGSQL_DML_STRING); ?> Expected result: ---------------- INSERT INTO t_test (c1,"C2") VALUES ('0','0'); Actual result: -------------- INSERT INTO t_test (c1,C2) VALUES ('0','0'); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40198&edit=1