Re: storing TZ along timestamps

Excerpts from Robert Haas's message of vie jul 22 11:33:09 -0400 2011:

> This problem reminds me a great deal of the problems associated with
> managing security labels for SE-Linux.  There aren't that many
> distinct values, so ideally it would be nice to store an OID -> string
> mapping somewhere and just store the OIDs in the main table.  But a
> new security label can appear at any time, and it doesn't work to have
> the transaction that discovers it do the insert into the mapping
> table.  Time zones have the same problem, more or less.  Now, maybe if
> we had non-transactional tables like Alvaro keeps muttering about...

Oh, I wasn't relating these problems to non transactional tables ...
Hmm.

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