From: | Dmitry Lazurkin <dilaz03(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Change location of function/type installed from C-extension |
Date: | 2017-08-26 12:26:47 |
Message-ID: | 8bbf866e-da2b-d415-33ae-45c6c744810b@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-08-26 13:29:56 | Re: Retrieving query results |
Previous Message | Dmitry Lazurkin | 2017-08-26 12:10:49 | Re: Change location of function/type installed from C-extension |