Re: BUG #2648: I can not create table name with capital and small characters - Mailing list pgsql-bugs

From Bruno Wolff III
Subject Re: BUG #2648: I can not create table name with capital and small characters
Date
Msg-id 20060929053402.GA32365@wolff.to
Whole thread Raw
In response to Re: BUG #2648: I can not create table name with capital and small characters  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-bugs
On Mon, Sep 25, 2006 at 14:59:46 +0200,
  Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
> Asaf,
>
> SQL-92 states that identifiers [for dictionary objects] are limited to 128
> characters and are case-insensitive (unless delimited by double quotes),
> because they are automatically translated into uppercase by the system.

Note that Postgres actually lowercases unquoted names instead of uppercasing
them. This difference can be significant.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2656: Fails to build on Intel Mac
Next
From: "Dave Page"
Date:
Subject: Re: BUG #2644: pgadmin III foreign key