Unix 2038 And PostgreSQL - Mailing list pgsql-general

From Sai Hertz And Control Systems
Subject Unix 2038 And PostgreSQL
Date
Msg-id 3FE7149F.5030508@sancharnet.in
Whole thread Raw
List pgsql-general
Dear all,

Before reading all this let me assure you nothing is out of control just
DONT PANIC!!!!

I was just going through the pages of  http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to

Fri Dec 13 20:45:52 1901

after

Tue Jan 19 03:14:07 2038

Now this was very serious for me as my clients use big dates for work
though my linux system indicated  it would be effected by 2038 (Run the
perl script available on that site)

but a quick

select  date'2038-01-19'  +  1;
gave me result

2038-01-20
Now that was what I looking for
I believe that PostgreSQL guys have worked around the 2038 problem

any suggestions and further finding's are most welcome.

My Systems Config is ,
PostgreSQL 7.3.4
RH 9.0

Regards,
Vishal Kashyap.

Related Links ...
http://news.com.com/2100-7355-5129875.html
http://www.unix-systems.org/version2/whatsnew/year2000.html
http://www.UNIX-systems.org/go/unix <http://www.unix-systems.org/go/unix>.
http://developers.slashdot.org/developers/03/12/21/1952207.shtml?tid=126&tid=128&tid=156

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Tables Referencing themselves As Foreign Keys
Next
From: "scott.marlowe"
Date:
Subject: Re: Salvage older PostgreSQL data disk - help?