John Lumby <johnlumby@hotmail.com> writes:
> I do have other databases in my cluster which probably explains the different datlastsysoid.
No, it wouldn't. datlastsysoid only counts objects created during
initdb.
[ thinks for a bit ] The most likely explanation for the different
datlastsysoid value is that the number of pre-created pg_collation
entries is quite a bit different on my box than yours, as a result of a
different list from "locale -a". It's hard to see why that would have
anything to do with your issue, but I have a feeling it does somehow.
What platforms have you tried this on, exactly? I tried it on Fedora 14.
> What are the values of relevant locale-type env vars when you ran initdb on your test sys?
Shrug ... C. That's my normal working environment. I did try it with
en_US.utf8 too, just for grins.
regards, tom lane