On Mar 1, 2011, at 1:12 PM, Tom Lane wrote:
> Collation, not correlation.
Yeah, I'm fat-fingered today.
> The question is what collation property the
> citext type needs to have, and how we get it to have that setting during
> an upgrade from 9.0. See
> http://archives.postgresql.org/message-id/11548.1297983024@sss.pgh.pa.us
Ah, I remember now. That lead to this:
http://archives.postgresql.org/pgsql-hackers/2011-02/msg01824.php
So it looks like what Peter said about updating the catalog is what needs to be done, and is simple, yes? But then pg_dump needs more collation-juju. Am I right?
Best,
David