Floating point timestamps

Started by Thomas Munroalmost 10 years ago4 messages
#1Thomas Munro
thomas.munro@enterprisedb.com

Hi,

Is the plan to remove support for floating point timestamps at some
stage? If so, what is that waiting on, and would it provide
sufficient warning if (say) 9.6 were documented as the last major
release to support that build option?

Thanks!

--
Thomas Munro
http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thomas Munro (#1)
Re: Floating point timestamps

Thomas Munro <thomas.munro@enterprisedb.com> writes:

Is the plan to remove support for floating point timestamps at some
stage? If so, what is that waiting on, and would it provide
sufficient warning if (say) 9.6 were documented as the last major
release to support that build option?

AFAIK there is no particular plan to do that. It's not like leaving
that code in place is costing us huge amounts of maintenance effort.

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Stephen Frost
sfrost@snowman.net
In reply to: Tom Lane (#2)
Re: Floating point timestamps

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Thomas Munro <thomas.munro@enterprisedb.com> writes:

Is the plan to remove support for floating point timestamps at some
stage? If so, what is that waiting on, and would it provide
sufficient warning if (say) 9.6 were documented as the last major
release to support that build option?

AFAIK there is no particular plan to do that. It's not like leaving
that code in place is costing us huge amounts of maintenance effort.

Agreed, and I have little doubt that it's still used in the field given
how long it was the default for some distributions.

Thanks!

Stephen

#4Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Stephen Frost (#3)
Re: Floating point timestamps

Stephen Frost wrote:

* Tom Lane (tgl@sss.pgh.pa.us) wrote:

Thomas Munro <thomas.munro@enterprisedb.com> writes:

Is the plan to remove support for floating point timestamps at some
stage? If so, what is that waiting on, and would it provide
sufficient warning if (say) 9.6 were documented as the last major
release to support that build option?

AFAIK there is no particular plan to do that. It's not like leaving
that code in place is costing us huge amounts of maintenance effort.

Agreed, and I have little doubt that it's still used in the field given
how long it was the default for some distributions.

... and the fact that you can pg_upgrade from old versions that had such
defaults, but only if the new install uses the same datetime
representation. IOW it's quite likely that there are versions in the
field still working with FP datetimes.

--
�lvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers