User-defined SRIDs are not working after Postgis 3.3.2 to 3.5.3 update

[Erik Wienhold]

On 2025-07-25 15:53 +0200, Alexander Trufanov wrote:
> >Can you please check which namespaces PostGIS finds with these two
> queries:
> > SELECT extnamespace::regnamespace FROM pg_extension WHERE extname =
> 'postgis';
> > SELECT pronamespace::regnamespace FROM pg_proc WHERE proname =
> 'postgis_full_version';
> 
> Both return "public".
> 
> The full result record from pg_extension is
> https://pastebin.com/raw/6mwrGhmH
> For pg_proc it's: https://pastebin.com/a4pTVs9U

I wouldn't rule out an index corruption in pg_catalog.  PostGIS gets the
extension namespace by first getting the OID of extension "postgis" and
then looking up the pg_extension row with that OID.  Maybe index
"pg_extension_oid_index" is corrupted.

Can you fix it by rebuilding the catalog indexes?:

	REINDEX SCHEMA pg_catalog;

-- 
Erik Wienhold