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
