Re: Why is time with timezone 12 bytes? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Why is time with timezone 12 bytes?
Date
Msg-id 1285269397-sup-8036@alvh.no-ip.org
Whole thread Raw
In response to Re: Why is time with timezone 12 bytes?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Excerpts from Robert Haas's message of jue sep 23 14:33:06 -0400 2010:

> I'm worried about how we're going to manage that.  First, as
> pg_upgrade becomes more mature, the penalty for breaking on-disk
> compatibility gets a LOT bigger.  I'd like to think that "the next
> time we break on-disk compatibility" means approximately "never", or
> at least "not for a very long time".  Second, if we do decide to break
> it, how and when will we make that decision?

I liked your earlier suggestion: if somebody wants to pg_upgrade, he
needs to go to the latest minor release of their branch, run some
command to upgrade the on-disk format (say ALTER TABLE / SET TYPE), and
*then* upgrade.

Now if it was workable to handle floating-point datetimes to integer
datetimes this way, it would be excellent.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: wip: functions median and percentile
Next
From: Bruce Momjian
Date:
Subject: pg_upgrade pain; was Re: Why is time with timezone 12 bytes?