Re: " keywords... Is it normal ?

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: blacknoz(at)club-internet(dot)fr, diego(at)adminsa(dot)com, pgadmin-hackers(at)postgresql(dot)org, miha(dot)radej(at)siix(dot)com
Subject: Re: " keywords... Is it normal ?
Date: 2004-09-10 10:11:50
Message-ID: 41417DE6.8070501@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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 :-) ).

Yeah, seems I introduced more problems than fixing.
Just introduced qtTypeIdent which will not quote types that are known to
the parser. Anybody is invited to review the list in needsQuoting
(utils/misc.c) taken from include/parser/parse.h. Diego's list was a
starter, but by far not complete.

IMHO quoting column names that are keywords should remain, to indicate
to the user that he's doing something he might want to review.

Regards,
Andreas

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message blacknoz 2004-09-10 11:16:11 Re: Beta 1
Previous Message cvs 2004-09-10 10:00:47 CVS Commit by andreas: fix type quoting