Thread: Quotes not included when clicking on a table?

Hello everybody,

I have a table called "user" (with the quotes). When I click on the table I
always get an error box:

'An error occured:

ERROR: parser: parse error at or near "user" at character 37'

When I click on another table, with name that's not special everythings
working just fine.

The version of pgAdmin I'm using is 1.0.2.

Sorry if it is a known bug, or isn't a bug at all.

Regards,
Kouber Saparev

Kouber Saparev wrote:
> Hello everybody,
> 
> I have a table called "user" (with the quotes). When I click on the table I
> always get an error box:

Poor guy...
We currently qoute identifiers only based on identifier rules, not 
checked against keywords. It's still a todo, because we had build 
problems on *ix.

Regards,
Andreas

> Poor guy...
> We currently qoute identifiers only based on identifier rules, not
> checked against keywords. It's still a todo, because we had build
> problems on *ix.

Yeah, it's natural not to rely on the keywords, but to put always double
quotes around identifiers.

Thank you.

K.

Kouber Saparev wrote:
>>Poor guy...
>>We currently qoute identifiers only based on identifier rules, not
>>checked against keywords. It's still a todo, because we had build
>>problems on *ix.
> 
> 
> Yeah, it's natural not to rely on the keywords, but to put always double
> quotes around identifiers.

Don't enter quotes in the name field of dialogs, you will provoke other 
misbehaviour (quoting the quotes). Unfortunately, you'll have to use 
"manual" sql. You can prepare the query with the wizard, but don't 
execute it. Instead, copy the contents of the SQL tab to the query tool, 
and add the missing quotes.


Regards,
Andreas