From: Ken Johanson <pg-user@kensystem.com>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: Martijn van Oosterhout <kleptog@svana.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Case Preservation disregarding case
Date: Sat, 02 Dec 2006 09:48:38 -0700
Message-ID: <4571AE66.7050304@kensystem.com> (raw)
In-Reply-To: <4571A3AF.6070608@zigo.dhs.org>
References: <200610271623.37525.beauh@bluefrogmobile.com>
<1162003132.687.8.camel@pampa>
<200610301928.51255.beauh@bluefrogmobile.com>
<23177.1162265010@sss.pgh.pa.us>
<EB48EBF3B239E948AC1E3F3780CF8F88012F88DD@MI8NYCMAIL02.Mi8.com>
<45712E31.1030004@kensystem.com>
<20061202133556.GC26365@svana.org>
<457199E4.3010401@kensystem.com>
<4571A3AF.6070608@zigo.dhs.org>
Dennis Bjorklund wrote:
> Ken Johanson skrev:
>
>> Has your experience with PG been different? If so I presume you have
>> have found a config that allows?:
>>
>> SELECT
>> pers.firstName,
>> pers.lastname,
>
> As long as you don't create the columns using quotes you can use that
> kind of names. For example
>
> CREATE TABLE foo (BAR int);
>
> INSERT INTO foo VALUES (42);
>
> SELECT BaR, bar, BAR, "bar" FROM foo;
>
> But using "Bar" wont work.
>
> /Dennis
>
That definitely makes sense. If one *wants* to enforce case, they should
create the identifier with quotes.
Although, since I'm using pgAdmin (III) to design tables in this case,
or creating the tables through JDBC (a convenient way to copy tables and
data from another datasource) (using the copy-paste gesture), I believe
those tools both *are* quoting identifiers that have camel case. And
that their behavior can't be overridden.
So though I might personally be comfortable with DDL commands to
re-define my existing quoted columns (as created by JDBC and pgAdmin),
other users may not be. And having to recreate and issue the DDL to use
un-quoted col names will be tedious in my case since I have ~20 tables
to import.
So my vote would remain for having a config-option to ignore case, even
on quoted identifiers..
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pg-user@kensystem.com, db@zigo.dhs.org, kleptog@svana.org
Subject: Re: [HACKERS] Case Preservation disregarding case
In-Reply-To: <4571AE66.7050304@kensystem.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox