Re: Why is time with timezone 12 bytes?

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