Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.

Refuse to run against postgres with a non-C collation #6722

Description

@richvdh

A number of people have reported (#6696) database index corruption which basically stems from their databases having a UTF-8 collation setting.

Our documentation tells you to set the collation to "C" to avoid this sort of thing (and possibly improve performance, according to postgres-general), but this is little comfort to people who missed that advice and now have corrupt indexes to deal with.

By way of a preventative measure, maybe we should complain if somebody is using a different collation?

synapse=# SELECT datcollate FROM pg_database WHERE datname = current_database();
 datcollate 
------------
 C
(1 row)

Metadata

Metadata

Assignees

No one assigned

    Labels

    z-p2(Deprecated Label)

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions