#28020 [Opn->Bgs]: tablenames not double quoted

ID: 28020 Updated by: sniper@php.net Reported By: Marco_de_Wit at wxs dot nl -Status: Open +Status: Bogus Bug Type: PostgreSQL related Operating System: Linux Mandrake 10 PHP Version: 4.3.4 New Comment: 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. .. Previous Comments: ------------------------------------------------------------------------ [2004-04-16 05:31:36] 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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=28020&edit=1