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-07T15:09:15Z
Lists: pgsql-bugs

Attachments

Hi,

> > > 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.

Here is the patch.

-- 
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.