Re: Issues with inconsistent COLLATION installation

Cory Nemelka <cnemelka@gmail.com> writes:
> Here is encoding for existing database:
>                                   List of databases
> ┌───────────┬──────────┬──────────┬─────────────┬─────────────┬───────────────────────┐
> │   Name    │  Owner   │ Encoding │   Collate   │    Ctype    │   Access
> privileges   │
> ├───────────┼──────────┼──────────┼─────────────┼─────────────┼───────────────────────┤
> │ thedatabase │ postgres │ UTF8     │ en_US.UTF-8 │ en_US.UTF-8 │
>             │

Hmm.  It's interesting that the collate/ctype locales say "UTF-8"
where locale -a says "utf8".  It's not apparent to me what relation
that might have to your observed problem, but it suggests that
this cluster doesn't exactly have a pristine history.  Did you
perhaps try to move the data files from one platform to another?

            regards, tom lane