Re: TODO Item: Consider allowing control of upper/lower case folding of unquoted, identifiers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: TODO Item: Consider allowing control of upper/lower case folding of unquoted, identifiers
Date
Msg-id 20336.1206665840@sss.pgh.pa.us
Whole thread Raw
In response to Re: TODO Item: Consider allowing control of upper/lower case folding of unquoted, identifiers  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> "Martijn van Oosterhout" <kleptog@svana.org> writes:
>> Will this change break my code?

> Well, DBI already has to deal with this anyways because it tries to provide a
> database-independent interface. So you can instruct DBI to upcase, downcase,
> or leave the identifiers as the database provides them by setting this
> property on your database connection:

That's not a solution, that's a kluge with very obvious failure modes.

Now admittedly it's probably not *likely* that someone would use
identifiers differing only in case in a single table definition.
But it's legal, and in fact we're required by spec to support it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: Status of GIT mirror (Was having problem in rsync'ing cvs)
Next
From: "Gurjeet Singh"
Date:
Subject: Re: pg_standby for 8.2 (with last restart point)