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
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 |
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 |
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 |