John Lumby <johnlu...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs