Re: [GENERAL] Change location of function/type installed from C-extension

On 26.08.2017 15:10, Dmitry Lazurkin wrote:
> I try investigate where PotsgreSQL keeps path of load libraries in catalog.
>
> select version();
>                                                        version
>
----------------------------------------------------------------------------------------------------------------------
> PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
> 5.4.0-6ubuntu1~16.04.4) 5.4.0 20160609, 64-bit
>
>
> select oid, datname from pg_database where datname = 'user';
>
>   oid  | datname
> -------+---------
>  16384 | user
>
>
> $ grep --text --null-data '$libdir/pg_trgm' data/test/base/16384/*
>
> data/test/base/16384/11829:set_limit!$libdir/pg_trgm ...
>
>
> select relname, relfilenode from pg_class where relfilenode = 11829;
>  relname | relfilenode
> ---------+-------------
> (0 rows)
>
>
> Hmmm. Where is table with filenode 11829?
>
> Thanks.
>

This is pg_proc.

inst/test/bin/oid2name -d user -f 11829
From database "user":
  Filenode  Table Name
----------------------
     11829     pg_proc