Re: Fwd: postgresql-autodoc - missinterprets "version" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Fwd: postgresql-autodoc - missinterprets "version"
Date
Msg-id 2505.1089431907@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fwd: postgresql-autodoc - missinterprets "version"  (Martin Pitt <martin@piware.de>)
List pgsql-bugs
Martin Pitt <martin@piware.de> writes:
> On 2004-07-08  7:10 -0700, Stephan Szabo wrote:
>> It doesn't appear to be necessary to quote the identifier, however version
>> and "version" refer to the same identifier in this case so I wouldn't call
>> it an error, either.

> This makes sense, thank you. I reassigned this bug to
> postgresql-autodoc. Just ignoring the quotes cannot be that
> difficult...

I am not sure why VERSION is a keyword, since AFAICS it is not used in
any production in gram.y.  Also, I've been harboring thoughts of fixing
things so that quote_identifier wouldn't quote "unreserved" keywords.

But having said that, it's surely postgresql-autodoc's fault that it
cannot cope with quoted identifiers.  There *will* be cases where PK
field names are quoted, such as mixed-case identifiers --- you do not
need a keyword collision to make that happen.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Improper processing of random values in sub-queries
Next
From: Tom Lane
Date:
Subject: Re: Bug related with permissions - VIEWS and RULES