I wonder if you could make an SQL type that used text[] as its storage format
but had an output function that displayed the correct text for the "current
locale". Where "current locale" could be something you set by calling a
function at the beginning of the transaction.
Do pg_dump and all the important things use the send/receive functions not the
input/output functions? so even though this output function loses information
it wouldn't cause serious problems?
You would still need a way to retrieve all the languages for the cases like
administrative interfaces for updating the information. I'm not entirely
convinced this would be any better than the alternative of retrieving all of
them by default and having a function to retrieve only the correct language.
--
greg