Re: BUG #2648: I can not create table name with capital and small characters

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
Cc: Asaf Avraham <asaf(dot)avraham(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2648: I can not create table name with capital and small characters
Date: 2006-09-29 05:34:02
Message-ID: 20060929053402.GA32365@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Sep 25, 2006 at 14:59:46 +0200,
Harald Armin Massa <haraldarminmassa(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Cemin Giovanni 2006-09-29 08:06:37 BUG #2663: backup with oids don't save table oids
Previous Message Tom Lane 2006-09-28 20:58:27 Re: BUG #2656: Fails to build on Intel Mac