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

Re: Locale-dependent case conversion in {identifier}

From: "Nicolai Tufar" <ntufar(at)apb(dot)com(dot)tr>
To: "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Locale-dependent case conversion in {identifier}
Date: 2002-11-30 21:18:34
Message-ID: 003a01c298b6$0ae42970$8016a8c0@apb.com.tr (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
----- Original Message -----
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>
Sent: Saturday, November 30, 2002 5:41 PM
Subject: Re: [HACKERS] Locale-dependent case conversion in {identifier}


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

That seem to be the case. All the databases I used, automaticaly convert
identifiers to upper case.
And they all do it using ASCII-only conversion.

>
> Could you try the grant in both databases also in lower case ?
>
> i.e.:
>
> grant select on a to public;

The statement works in both databases. But the problem is that it was
pg_dumpall who created SQL statements with PUBLIC. Why
pg_dumpall does not enclose identifiers in quotes, like:

REVOKE ALL ON TABLE "tamara2" FROM "public";
      insted of
REVOKE ALL ON TABLE tamara2 FROM PUBLIC;
as it does now.

I will make an attempt to modify pg_dump accordingly, and will send a
patch to the list.


Regards,
Nic


In response to

Responses

pgsql-hackers by date

Next:From: Joe ConwayDate: 2002-11-30 21:44:40
Subject: Re: 7.4 Wishlist
Previous:From: Joe ConwayDate: 2002-11-30 21:11:20
Subject: Re: [GENERAL] One SQL to access two databases.

pgsql-advocacy by date

Next:From: Joe ConwayDate: 2002-11-30 21:44:40
Subject: Re: 7.4 Wishlist
Previous:From: Dan LangilleDate: 2002-11-30 20:19:09
Subject: Re: 7.4 Wishlist

pgsql-general by date

Next:From: Tom LaneDate: 2002-11-30 21:26:52
Subject: Re: strange pg_stats behaviour?
Previous:From: Joe ConwayDate: 2002-11-30 21:11:20
Subject: Re: [GENERAL] One SQL to access two databases.

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