php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #40198 Column name is not double quoted
Submitted: 2007-01-22 18:53 UTC Modified: 2007-11-26 01:00 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: chores at jp1 dot cx Assigned: yohgaki (profile)
Status: No Feedback Package: PostgreSQL related
PHP Version: 5.2.4 OS: FreeBSD 6.2
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2007-01-22 18:53 UTC] 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');

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-01-23 00:26 UTC] chores at jp1 dot cx
Expected result (Correction):
-----------------------------
INSERT INTO "t_test" ("c1","C2") VALUES ('0','0');
 [2007-11-17 06:02 UTC] chores at jp1 dot cx
non-fix v5.2.4
 [2007-11-18 23:48 UTC] jani@php.net
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..
 [2007-11-26 01:00 UTC] 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".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Apr 24 00:01:32 2024 UTC