Try on both servers:show lc_collate Unfortunately you have to initdb to set the locale. You can't set it per database or change it once it's initialized.
Right you are, but I suppose I can do a dump using pg_dumpall overwrite the cluster with initdb --locale=en_US and restore it again without the different collation giving problems ? Poul ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
