Re: Possible old and fixed bug in Postgres?

Erik Wienhold <ewie@ewie.name> writes:
>> On 05/04/2023 11:18 CEST Steve Rogerson <steve.git@woodsideendurance.co.uk> wrote:
>>     # For very early and late dates, PostgreSQL always returns times in
>>     # UTC and does not tell us that it did so.
>> Early is before 1901-12-14 and late after 2038-01-18
>> ...
>> These seemed correct to me. I'm guessing this might have been a bug/feature of
>> pg in the long ago.

> Judging by the commit message and changed test cases, probably:

> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=921d749bd4c34c3349f1c254d5faa2f1cec03911

I think this was not fixed in full until 2008:

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=0171e72d4da2da7974ff13c63130e2175cebee88

Either way, though, whatever Steve is looking at is far past its
sell-by date.

            regards, tom lane