Re: Internationalization

On Wed, Jun 30, 2004 at 02:26:10PM -0700, Dennis Gearon wrote:

> 1/ Make individual databases possible with a single instance that can be
> different encoding AND locale/sorting, and all other aspects of using
> the encoding/langauge rules.

> Is there anyway for a single statement to access more than one database?
> Could a query, regexes, etc be facing indexes in different
> encodings/sorting collations if different databases in a cluster had
> different encodings/collations?

No, but there are at least two problems:

1. shared tables.  All databases in each cluster shared at least
pg_database, pg_shadow, pg_group and (new) pg_tablespace.  And, of
course, all their indexes.  What would you do about them?

2. when creating a new database, the current method is to copy from
template1.  How would you change the encoding of the new database?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The problem with the future is that it keeps turning into the present"
(Hobbes)