Re: [BUG?] SET TIME ZONE doesn't work with abbreviations

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUG?] SET TIME ZONE doesn't work with abbreviations
Дата
Msg-id CAKFQuwaC8_0aFo2XCe3-i6OP_Unio+9p_ek+54HCoSta7=zpZA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUG?] SET TIME ZONE doesn't work with abbreviations  (Aleksander Alekseev <aleksander@timescale.com>)
Список pgsql-hackers
Дерево обсуждения
On Tuesday, September 7, 2021, Aleksander Alekseev <aleksander@timescale.com> wrote:
Hi hackers,

I noticed that `SET TIME ZONE` / `SET timezone TO` don't work with
abbreviations:

Is it a bug or this behavior is intentional (something to do with SQL
standard, perhaps)?


Well, given that the limitation is documented I’d have to say it is intentional:

You cannot set the configuration parameters TimeZone or log_timezone to a time zone abbreviation, but you can use abbreviations in date/time input values and with the AT TIME ZONE operator.


David J.

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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Use "superuser" instead of "super user" in code comments
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUG?] SET TIME ZONE doesn't work with abbreviations