Postgres Pro
Downloads
Home   >   mailing lists

Re: collector's time is wrong.(year 2038 problem) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: collector's time is wrong.(year 2038 problem)
Date
Msg-id 26502.1478097304@sss.pgh.pa.us
Whole thread Raw
In response to collector's time is wrong.(year 2038 problem)  (石原 和樹<Kazuki.Ishihara@keisetsu.jp>)
List pgsql-bugs
Tree view 
=3D?iso-2022-jp?B?GyRCQFA4NhsoQiAbJEJPQjx5GyhC?=3D <Kazuki.Ishihara@keiset=
su.jp> writes:
> 1.     Change current time. (e.g. Sep. 1st 2040)
> 2.     Start PostgreSQL Service.

This is not going to work on any platform that uses 32-bit time_t.
It's not our bug, it's that the system time API doesn't work after 2038.

The short answer is that you're not going to still be using Windows 8
in 2040, so don't worry about it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: 石原 和樹
Date:
Subject: collector's time is wrong.(year 2038 problem)
Next
From: Jamie Koceniak
Date:
Subject: Re: BUG #14399: Order by id DESC causing bad query plan