Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUG?] SET TIME ZONE doesn't work with abbreviations - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: [BUG?] SET TIME ZONE doesn't work with abbreviations
Date
Msg-id CAKFQuwaC8_0aFo2XCe3-i6OP_Unio+9p_ek+54HCoSta7=zpZA@mail.gmail.com
Whole thread Raw
In response to [BUG?] SET TIME ZONE doesn't work with abbreviations  (Aleksander Alekseev <aleksander@timescale.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Use "superuser" instead of "super user" in code comments
Next
From: Tom Lane
Date:
Subject: Re: [BUG?] SET TIME ZONE doesn't work with abbreviations