Re: Locale-dependent case conversion in {identifier}

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Nicolai Tufar <ntufar(at)apb(dot)com(dot)tr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Locale-dependent case conversion in {identifier}
Date: 2002-11-30 15:41:17
Message-ID: 1038670876.9216.2.camel@huli
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-general pgsql-hackers

On Sat, 2002-11-30 at 01:40, Nicolai Tufar wrote:
> And I happen to have bad luck to use PostgreSQL with Turkish locale. And, as
> you
> may know our "I" is not your "I":
>
> pgsql=# create table a(x char(1));
> CREATE TABLE
> pgsql=# grant SELECT ON a to PUBLIC;
> ERROR: user "public" does not exist
> pgsql=#
>
> Oracle, the second best database I have does seem to convert relation names
> in
> locale-dependent fassion:
>
> SQL> alter session set NLS_LANGUAGE='TURKISH';
> Session altered.
> SQL> create table a(x char(1));
> Table created.
> SQL> grant select on a to PUBLIC;
> Grant succeeded.

could it just be that we store identifiers in lower case, whereas most others
(including SQL spec IIRC)have them in upper case ?

Could you try the grant in both databases also in lower case ?

i.e.:

grant select on a to public;

------------------
Hannu

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Hannu Krosing 2002-11-30 15:47:58 Re: Locale-dependent case conversion in {identifier}
Previous Message Horacio Miranda 2002-11-30 14:54:11 about ODBC

Browse pgsql-general by date

  From Date Subject
Next Message Hannu Krosing 2002-11-30 15:47:58 Re: Locale-dependent case conversion in {identifier}
Previous Message Christoph Dalitz 2002-11-30 15:05:04 Re: ALTER TABLE & COLUMN

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-11-30 15:47:58 Re: Locale-dependent case conversion in {identifier}
Previous Message Adrian 'Dagurashibanipal' von Bidder 2002-11-30 14:59:48 Re: eWeek Article