Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-advocacy by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group