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>, Laurenz Albe <laurenz.albe@cybertec.at>, Michael Paquier <michael@paquier.xyz>
Date: 2025-01-07T12:39:07Z
Lists: pgsql-bugs 
Hi,

> Anyway, I've started a -hackers thread about this issue at [1].
> Whatever we do probably deserves wider discussion than it will
> get on pgsql-bugs.
>
>                         regards, tom lane
>
> [1] https://www.postgresql.org/message-id/957280.1734046384%40sss.pgh.pa.us

Thanks, Tom. For the record, I'm closing the CF entry for my patch as
RwF since clearly the patch was wrong and the issue needs more
discussion.

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