Skip site navigation (1) Skip section navigation (2)

Re: Why is abstime type deprecated?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kilian Hagemann <hagemann1(at)egs(dot)uct(dot)ac(dot)za>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Why is abstime type deprecated?
Date: 2004-10-27 14:40:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Kilian Hagemann <hagemann1(at)egs(dot)uct(dot)ac(dot)za> writes:
> After long googling I found that abstime, as was still current in 6.x, would 
> do the trick for me. But the 7.x documentation says "You are discouraged from 
> using these types in new applications" and that "Any or all of these internal 
> types might disappear in a future release". The Version 8.0 History file 
> makes no indication of abstime disappearing, but I'm still worried about 
> implementing my database with abstime. Why is it deprecated?

Because it will certainly break by 2038, when 32-bit time_t overflows.

In practice, Unix systems will have to move to 64-bit time_t before
that, and we'll probably either remove abstime or make it an 8-byte type
as soon as that practice is common.

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Kilian HagemannDate: 2004-10-27 15:08:07
Subject: Re: Why is abstime type deprecated?
Previous:From: Kilian HagemannDate: 2004-10-27 13:44:15
Subject: Why is abstime type deprecated?

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group