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

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:10:49
Message-ID: 612a84a6-f8b8-6285-a34e-115fd3d497be@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Lazurkin 2017-08-26 12:26:47 Re: Change location of function/type installed from C-extension
Previous Message Tim Uckun 2017-08-26 09:52:55 Immutable functions and cache invalidation.