Re: [BUGS] PG do not accept quoted names for tables/columns

2003-02-06 Thread Tom Lane
Yaniv Hamo <[EMAIL PROTECTED]> writes: > shared# CREATE TABLE 'testtable' ('test' INT); > ERROR: parser: parse error at or near "'testtable'" at character 14 This is not a bug. (Perhaps you were looking for double quotes "..." not single quotes '...' ?) regards, tom lane

Re: [BUGS] PG do not accept quoted names for tables/columns

2003-02-06 Thread Andrew McMillan
On Thu, 2003-02-06 at 22:26, Yaniv Hamo wrote: > Hi, > I noticed that Postgres issues a fatal error when given a quoted name of > table or column. This is a problem in secured cgi scripts, which quote > everything they get from the user, to avoid malicious users from trying to > execute SQL comma

Re: [BUGS] PG do not accept quoted names for tables/columns

2003-02-06 Thread Stephan Szabo
On Thu, 6 Feb 2003, Yaniv Hamo wrote: > I noticed that Postgres issues a fatal error when given a quoted name of > table or column. This is a problem in secured cgi scripts, which quote > everything they get from the user, to avoid malicious users from trying to > execute SQL commands using some e

[BUGS] PG do not accept quoted names for tables/columns

2003-02-06 Thread Yaniv Hamo
Hi, I noticed that Postgres issues a fatal error when given a quoted name of table or column. This is a problem in secured cgi scripts, which quote everything they get from the user, to avoid malicious users from trying to execute SQL commands using some engineered input. shared# select versio