To: alwin <alwin@cs.nl>
Cc: pgsql-admin@postgresql.org
Subject: Re: case insensitive table names 
In-reply-to: <6.1.2.0.0.20041012155623.025459c8@localhost> 
References: <6.1.2.0.0.20041012155623.025459c8@localhost>
Comments: In-reply-to alwin <alwin@cs.nl>
	message dated "Tue, 12 Oct 2004 16:18:01 +0200"
Date: Tue, 12 Oct 2004 10:50:44 -0400
Message-ID: <2292.1097592644@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

alwin <alwin@cs.nl> writes:
> So far so good. But the current code uses queries without quotes, like
> select * from Table; and not select * from "Table";.

You have a problem :-(

> Is there an easier fix for this? Does the SQL92/SQL3/SQL2003 specify
> unquoted table names to be case-insensitive or does it say it needs to
> be converted to lowercase?

The SQL spec is absolutely clear that the above code is wrong.  What the
spec actually says is that unquoted names should be forced to all upper
case (so Table is equivalent to "TABLE").  Postgres forces them to lower
case (so Table is equivalent to "table") which is not quite the same but
has the same effect that unquoted names are not case sensitive.  But
under both the exact spec rules and our rules, a mixed-case quoted name
is never equivalent to any unquoted name.  There is no such thing as
case insensitivity for quoted names.

			regards, tom lane