Aleksander Alekseev <aleksander(at)timescale(dot)com> writes:
> =# set datestyle to 'Postgres';
> SET
> =# SELECT '1000-01-01'::timestamptz::text::timestamptz;
> ERROR: invalid input syntax for type timestamp with time zone: "Wed
> Jan 01 00:00:00 1000 LMT"
> 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.
regards, tom lane