On Jan 16, 2007, at 11:52 , Jerry LeVan wrote:
The locale function on the mac has everything set to "C"
and on the linux box it is all "en_US.UTF-8".
Is there a simple way to get the collating sequences to be
the same on both boxen?
My understanding is that to have the same ordering you need to have
initdb'd with the same locale on both machines. Hopefully PostgreSQL
will have better collation support in the future.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
