Re: " keywords... Is it normal ?

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
>

In response to

Browse pgadmin-hackers by date

  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