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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
