Horton

Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'

Aleksander Alekseev <aleksander@timescale.com>

View thread View on postgr.es
From: Aleksander Alekseev <aleksander@timescale.com>
To: pgsql-bugs@lists.postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-11-07T14:38:25Z
Lists: pgsql-bugs 
Hi Tom,

> > If I understand correctly, text->timestamptz doesn't understand the
> > 'LMT' timezone.
>
> So it seems.  In a quick experiment, it seemed like just treating LMT
> as a noise word on input might be enough, but I don't have time today
> to poke at it further.

Thanks for the hint. I've found the corresponding piece of code and
will submit a proper patch shortly.

-- 
Best regards,
Aleksander Alekseev

Commits

  1. Seek zone abbreviations in the IANA data before timezone_abbreviations.

  2. Make pg_interpret_timezone_abbrev() check sp->defaulttype too.