php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #28020 tablenames not double quoted
Submitted: 2004-04-16 05:31 UTC Modified: 2004-04-16 15:09 UTC
From: Marco_de_Wit at wxs dot nl Assigned:
Status: Not a bug Package: PostgreSQL related
PHP Version: 4.3.4 OS: Linux Mandrake 10
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: Marco_de_Wit at wxs dot nl
New email:
PHP Version: OS:

 

 [2004-04-16 05:31 UTC] Marco_de_Wit at wxs dot nl
Description:
------------
if I make a table with a name like 'user' or 'order', any use with it in SQL should be double quoted for instance:

SELECT * FROM "user";

But pg_insert doesn't do this:
pg_insert($connection,'user',$fields);
will result in an error showing the tablename 'user' not between double quotes.


Reproduce code:
---------------
pg_insert($connection,'user',$fields);

Actual result:
--------------
[Fri Apr 16 11:29:34 2004] [error] PHP Notice:  pg_insert(): Failed to execute 'INSERT INTO user (name,username,password,email,region,number) VALUES ('','','','','',1);'. in /var/www/skileurope.com/displayshop/kernel.php on line 90


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-16 15:09 UTC] sniper@php.net
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.

..

 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 19 19:01:28 2024 UTC