Re: sql99 compat list

Tom Lane wrote:

>Shachar Shemesh <psql(at)shemesh(dot)biz> writes:
>
>
>>Also, I think a pretty simple workaround would be to have
>>PSQL search for the upper case identifier, and if not found, search for
>>the lower case. This should allow a migration path while the tools and
>>functions are being translated (and should, perhaps, stay around forever
>>as a session option for old databases)
>>
>>
>
>You're assuming that we plan to change this. We don't. Most of us
>prefer to look at lower-case identifiers.
>
> regards, tom lane
>
>
While I cannot argue with personal preferences, of course, I will try to
point out two things:
1. It's an SQL incompatibility, and therefor must be documented (at the
very least).
2. It is causing pains when performing migrations from other databases

At the very least, a session option that will allow me to search for
upper case if a lowercase identifier was not found would be apretiated,
optionally with a warning (so I can track down the places in the
migrated application that are still misbehaving, and fix them).

Shachar

--
Shachar Shemesh
Open Source integration consultant
Home page & resume - http://www.shemesh.biz/