Re: " keywords... Is it normal ?

hi!

in my case it also quotes only 1 column name (column name is "type"),
although it is lower-case:
http://mcajvar.prkoritu.net/pgadmin/pgadmin_quotes.png  (in the middle
of the query).
in another table, the column name "password" is also quoted and it's
also lower-case.
using v 1.1.0 devel, sep. 7 2004 on win2k.

regards,
M


Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: blacknoz@club-internet.fr [mailto:blacknoz@club-internet.fr]
>>Sent: 10 September 2004 10:03
>>To: diego@adminsa.com
>>Cc: pgadmin@pse-consulting.de; Dave Page;
>>pgadmin-hackers@postgresql.org
>>Subject: Re: Re: [pgadmin-hackers] " keywords... Is it normal ?
>>
>>
>>Also add the user name in the grant statements.
>>I've read some thread implying Andreas and quoted keywords.
>>I think Andreas or Dave added such feature to prevent some
>>misbehaviour while using reserved words in some conditions
>>but I don't know/remember/understand the scope of these modifications.
>>IMHO it should be reviewed as it breaks part of the tool.
>
>
> Andreas tweaked it a bit a little while ago:
>
> http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/src/utils/misc.cpp.d
> iff?r1=1.54&r2=1.55
>
> Seems we need a way to exclude keywords when used in their 'keyword
> defining' context (if that makes any sense :-) ).
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>