| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Randall Smith *EXTERN*" <randall(at)tnr(dot)cc>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: quoted identifier behaviour |
| Date: | 2007-03-15 10:41:18 |
| Message-ID: | AFCCBB403D7E7A4581E48F20AF3E5DB201B4AE1A@EXADV1.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Randall Smith wrote:
>>> Are there plans to make Postgresql's behavior SQL compliant with
regards
>>> to quoted identifiers? My specific need is to access tables named
in
>>> lower case by an uppercase quoted identifier, which is in line with
the
>>> SQL standard.
>>
>> You must not change the names of system tables, but you can
>> certainly create upper case views for them.
>
> That's my current solution. I imagine this is not very
> efficient, but I could be wrong.
I think that the performance impact is negligible.
The pain is to maintain the views - the catalog tables can
change in every new release...
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2007-03-15 10:49:46 | Re: database locks |
| Previous Message | Gloria Rodriguez | 2007-03-15 10:32:26 | java.net.SocketException: Connection reset |