pg_collation_actual_version() ERROR: cache lookup failed for collation 123 - Mailing list pgsql-hackers

From Justin Pryzby
Subject pg_collation_actual_version() ERROR: cache lookup failed for collation 123
Date
Msg-id 20210117215940.GE8560@telsasoft.com
Whole thread Raw
Responses Re: pg_collation_actual_version() ERROR: cache lookup failed for collation 123  (Thomas Munro <thomas.munro@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: pgbench: option delaying queries till connections establishment?
Next
From: Tom Lane
Date:
Subject: Re: Add primary keys to system catalogs