PostgreSQL 17 Collation Changes: Why It Broke Everything
If you’ve recently upgraded to PostgreSQL 17 and suddenly started seeing errors about colliculocale not existing, you’re not alone. This column was quietly renamed to colllocale in commit f696c0cd, breaking queries that relied on the old name.
Now, any code that referenced pg_collation.colliculocale throws errors because the column is just gone. Developers are left with two choices: update their queries or stick with an older PostgreSQL version.
For example, a query like this: