From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Adnan Dautovic <daut(at)mailbox(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Failure of postgres_fdw because of TimeZone setting |
Date: | 2024-04-10 21:25:38 |
Message-ID: | 6f432420-cb0e-4e2f-943c-26be2579bf53@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/10/24 1:31 PM, Tom Lane wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>> On 4/10/24 12:38, Adnan Dautovic wrote:
>>> By the way, the row count of pg_timezone_names is 385, but I do
>>> not know how that compares to a more standard installation.
>
>> On my instance of Postgres 16.2, 1196.
>
> You're probably using a build with --with-system-tzdata pointing
> at a system tzdata tree that includes leap-second-aware zones.
> These tend to have duplicative entries like "America/New_York"
> and "posix/America/New_York". (There's also a subtree like
> "right/America/New_York", but we reject those because we don't
> do leap seconds.) The real number of distinct zones in a
> standard tzdata file set these days is a shade under 600.
It's the PGDG package running on Ubuntu 22.04.
>
> regards, tom lane
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2024-04-10 22:47:09 | Re: (When) can a single SQL statement return multiple result sets? |
Previous Message | Jan Behrens | 2024-04-10 21:22:47 | (When) can a single SQL statement return multiple result sets? |