On Mon, Mar 28, 2005 at 12:16:42PM +0400, Alexey Slynko wrote:
> this patch allow to use database locale settings. It remove cluster locale
> settings, and append LCCTYPE and
> LCCOLLATE items to CREATE DATABASE syntax.
>
> Any considerations ?
The problem with this is what happens to indexes on shared relations.
If you change the collation, they are no longer valid. And you can't
just reindex them, because then they would no longer be valid for other
databases.
I havn't see any shared indices, that uses any variable collation, like text
indices. All shared indexed columns have integer and name type. As I understand,
all this types have fixed collation. Or I've missed something ?
Maybe it would work if we forced indexes on shared relations to be
scanned using a fixed collation.
Not sure about the ctype part ...
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Los romАnticos son seres que mueren de deseos de vida"
Alexey Slynko
E-mail: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
