Re: Problems viewing a table called "user" in pgAdmin 1.3.6

> -----Original Message-----
> From: Johan Mjönes [mailto:johan(dot)mjones(at)agent25(dot)se]
> Sent: 13 August 2002 13:02
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problems viewing a table called
> "user" in pgAdmin 1.3.6
>
>
> Hello,
>
> We're having problems with the new dev version av pgAdmin II,
> since it can't properly display one of our tables called
> "user" (pgAdmin II 1.2 had no problem neither creating nor
> viewing it). When the properties are loading, the parser says
> 'parse error at or near "user"' (did someone forget to quote? ;)
>

Hi,

I would guess that 'user' is a keyword that the parser doesn't like. 1.2.0 used to blindly quote everything which many people objected to. 1.3.60 only quotes identifiers with characters that aren't [0-9] [a-z] or _. I will need to look at checking a list of reserved words as well. In the meantime, you could manually type:

select * from "user"

In the SQL window.

Regards, Dave.