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

2017-08-26 Thread Dmitry Lazurkin
On 26.08.2017 22:05, Tom Lane wrote: > Dmitry Lazurkin writes: >> Thanks. Can I update "pg_proc.probin" without any problems? > Should work. I'd experiment in a scratch database before doing > it in production, but I can't think of a problem offhand. > >

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

2017-08-26 Thread Tom Lane
Dmitry Lazurkin writes: > Thanks. Can I update "pg_proc.probin" without any problems? Should work. I'd experiment in a scratch database before doing it in production, but I can't think of a problem offhand. regards, tom lane -- Sent via

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

2017-08-26 Thread Dmitry Lazurkin
On 26.08.2017 18:24, Tom Lane wrote: > You need to use pg_relation_filenode(): > > regression=# select relname, pg_relation_filenode(oid) from pg_class where > relname like 'pg_proc%'; > relname | pg_relation_filenode >

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

2017-08-26 Thread Tom Lane
Dmitry Lazurkin writes: > select relname, relfilenode from pg_class where relfilenode = 11829; > relname | relfilenode > -+- > (0 rows) > Hmmm. Where is table with filenode 11829? pg_class.relfilenode doesn't contain useful data for pg_proc and some other

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

2017-08-26 Thread Dmitry Lazurkin
On 26.08.2017 15:10, Dmitry Lazurkin wrote: > I try investigate where PotsgreSQL keeps path of load libraries in catalog. > > select version(); >version >

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

2017-08-26 Thread Dmitry Lazurkin
I try investigate where PotsgreSQL keeps path of load libraries in catalog. select version(); version -- PostgreSQL 9.3.4 on

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

2017-08-24 Thread Dmitry Lazurkin
Hello. I have database with installed pg_trgm extension with module path '/usr/lib/pg_trgm' (yes, this is mistake without $libdir (: ). Now I want upgrade postgresql to new major version. I keep old version 9.3 in /opt/postgresql/9.3 and new version 9.6 in /usr. Old version $libdir -