Postgres Pro
Downloads
Home   >   mailing lists

Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' - Mailing list pgsql-bugs

From Aleksander Alekseev
Subject Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'
Date
Msg-id CAJ7c6TMzJDLutYt+pcm1Jt+sDSRHjvjezM9o8heEoo_LwgP75A@mail.gmail.com
Whole thread Raw
In response to Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'
Next
From: Nathan Bossart
Date:
Subject: Re: Detection of hadware feature => please do not use signal