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

From Tom Lane
Subject Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'
Date
Msg-id 957591.1734046599@sss.pgh.pa.us
Whole thread Raw
In response to Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres'
List pgsql-bugs
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> I agree that something should be done, but I'd have no problem
> with deprecating the Postgres datestyle.  People who depend on
> it can switch to using to_date() and to_timestamp(), which
> shouldn't impose too much hardship if we give them enough time.

It's not like to_timestamp doesn't have the same problem...

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



pgsql-bugs by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: BUG #18711: Attempting a connection with a database name longer than 63 characters now fails
Next
From: Tom Lane
Date:
Subject: Re: Build failure with GCC 15 (defaults to -std=gnu23)