From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Reiner Dassing <dassing@wettzell.ifag.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Upper / lower cases on table and column names
Date: Fri, 25 Oct 2002 05:48:59 -0700 (PDT)
Message-ID: <20021025054139.C34720-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3DB93607.2050202@wettzell.ifag.de>
On Fri, 25 Oct 2002, Reiner Dassing wrote:
> I was trying to adopt a database application to PostgreSQL.
> (It is written for MySQL and Oracle using perl)
>
> During this process I recognized the phenomena that upper case letters
> of table names and column names are not preserved
> in PostgreSQL.
> Is this a "featue" of PostgreSQL or do I miss something?
There's some question about whether it should instead fold to upper
case, but in any case its a sort of cheat to handle the case
insensitivity of regular identifiers.
> create table data ( Id int not null, textId int not null);
> create table Data ( Id int not null, textId int not null);
>
> results in:
> ERROR: Relation 'data' already exists
>
> In the interpretation of my application table 'data' and 'Data' is something
> different.
AFAICT it shouldn't be. SQL92 basically says that two regular identifiers
are the equivalent if the identifer bodies compare equally. The
identifier bodies of a regular identifier are equivalent to an identifier
body in which each lower-case character is replaced with an upper case
one.
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: sszabo@megazone23.bigpanda.com, dassing@wettzell.ifag.de
Subject: Re: Upper / lower cases on table and column names
In-Reply-To: <20021025054139.C34720-100000@megazone23.bigpanda.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