Dennis Gearon <gearond(at)fireserve(dot)net> writes:
> 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?
The indexes on the shared system tables (eg, pg_database) are the only
issue here. One possible solution is to require that no locale-aware
datatypes ever be used in these indexes. I think right now this is true
because "name" doesn't use locale-aware sorting; but we'd have to be
careful not to break the restriction in future.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-07-01 01:38:08|
|Subject: Re: case for lock_timeout |
|Previous:||From: Tom Lane||Date: 2004-07-01 01:24:28|
|Subject: Re: ~Strange Operators~ |