From: | Miha Radej <miha(dot)radej(at)siix(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: " keywords... Is it normal ? |
Date: | 2004-09-10 08:46:02 |
Message-ID: | 414169CA.3010203@siix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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(at)club-internet(dot)fr [mailto:blacknoz(at)club-internet(dot)fr]
>>Sent: 10 September 2004 10:03
>>To: diego(at)adminsa(dot)com
>>Cc: pgadmin(at)pse-consulting(dot)de; Dave Page;
>>pgadmin-hackers(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | blacknoz | 2004-09-10 09:03:12 | Re: " keywords... Is it normal ? |
Previous Message | Dave Page | 2004-09-10 08:29:58 | Dave gets out the office for a change |