From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | Hiroshi Saito <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>, pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: pgAggregate problem any function |
Date: | 2003-09-09 11:15:47 |
Message-ID: | 3F5DB663.5080800@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Dave Page wrote:
>
>
>>-----Original Message-----
>>From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
>>Sent: 09 September 2003 11:50
>>To: Dave Page
>>Cc: Hiroshi Saito; pgadmin-hackers(at)postgresql(dot)org
>>Subject: Re: [pgadmin-hackers] pgAggregate problem any function
>>
>>
>>Hm,
>>
>>looking at the patch and the weird pgsql behaviour documented below I
>>doubt that this is the ultimate fix.
>>I suspect that
>>a) this should be handled in qtIdent()
>>b) other keywords might be affected, e.g. 'char'
>>
>>
>
>We looked at this in pga2 (and I think Frank did implement something in
>the end). The problem is that there is a huge list of reserved words
>that need checking
>(http://www.postgresql.org/docs/7.3/static/sql-keywords-appendix.html)
>90% of which noone is ever likely to name a type or domain after. Is it
>worth the overhead of searching the list in every call to qtIdent?
>
Didn't want to check all keywords, but there are some treated special,
and one of them is "char". I was wondering if "any" will make problems
in other places too, that's why I'd like to see it in qtIdent().
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-09-09 11:21:32 | Re: pgAggregate problem any function |
Previous Message | Dave Page | 2003-09-09 11:10:28 | Re: pgAggregate problem any function |