Re: quoted identifier behaviour

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: quoted identifier behaviour
Дата
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB201B4AE1A@EXADV1.host.magwien.gv.at
обсуждение исходный текст
Ответ на quoted identifier behaviour  (Randall Smith <randall@tnr.cc>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Chris Coleman"
Дата:
Сообщение: Re: Plperl Question
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: database locks