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

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'
Date: 2024-11-07 15:09:15
Message-ID: CAJ7c6TMpBUMLqep4ycxySN+SFsf-eG2v-nUaVSzu2jSd5eDMAA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
v1-0001-Make-LMT-an-ignored-date-time-keyword.patch application/octet-stream 2.8 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Nathan Bossart 2024-11-07 15:28:44 Re: Detection of hadware feature => please do not use signal
Previous Message Aleksander Alekseev 2024-11-07 14:38:25 Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'