pg_collation_actual_version() ERROR: cache lookup failed for collation 123

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_collation_actual_version() ERROR: cache lookup failed for collation 123
Date: 2021-01-17 21:59:40
Message-ID: 20210117215940.GE8560@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

As of 257836a75, this returns:

|postgres=# SELECT pg_collation_actual_version(123);
|ERROR: cache lookup failed for collation 123
|postgres=# \errverbose
|ERROR: XX000: cache lookup failed for collation 123
|LOCATION: get_collation_version_for_oid, pg_locale.c:1754

I'm of the impression that's considered to be a bad behavior for SQL accessible
functions.

In v13, it did the same thing but with different language:

|ts=# SELECT pg_collation_actual_version(123);
|ERROR: collation with OID 123 does not exist
|ts=# \errverbose
|ERROR: 42704: collation with OID 123 does not exist
|LOCATION: pg_collation_actual_version, collationcmds.c:367

--
Justin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-01-17 22:07:57 Re: Add primary keys to system catalogs
Previous Message Thomas Munro 2021-01-17 21:54:38 Re: pgbench: option delaying queries till connections establishment?