Re: proposal, patch: allow multiple plpgsql plugins - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: proposal, patch: allow multiple plpgsql plugins
Date
Msg-id CAFj8pRBnvnUBm3AijCnzFp5PGLhMVoPo29PDWcvYdrXCbqBTOQ@mail.gmail.com
Whole thread Raw
In response to Re: proposal, patch: allow multiple plpgsql plugins  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers



2014-03-03 6:09 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:


Dne 2. 3. 2014 21:55 "Marko Tiikkaja" <marko@joh.to> napsal(a):


>
> On 3/2/14, 8:47 PM, Pavel Stehule wrote:
>>
>> 2014-03-02 19:59 GMT+01:00 Marko Tiikkaja <marko@joh.to>:
>>>
>>> Undefined symbols for architecture x86_64:
>>>
>>>    "_plpgsql_register_plugin", referenced from:
>>>        __PG_init in plpgtest.o
>>>
>>> I'm guessing this is because PL/PgSQL is a shared library and not in core?
>>>   Is there a way around this?
>>>
>>
>> yes, PLpgSQL is not referenced and, if I remember well, clang is too
>> restrictive.
>>
>> probably
>> http://stackoverflow.com/questions/17281901/ignoring-an-undefined-symbol-in-a-dynamic-library-from-xcode
>>
>> or you can add a reference on plpgsql to your Makefile
>
>
> That seems unbelievably ugly, but worse, loading the library in shared_preload_libraries doesn't work:
>
> 14782  FATAL:  could not load library "/usr/local/pgsql/lib/plpgtest.so": dlopen(/usr/local/pgsql/lib/plpgtest.so, 10): Symbol not found: _plpgsql_register_plugin
>           Referenced from: /usr/local/pgsql/lib/plpgtest.so
>           Expected in: flat namespace
>          in /usr/local/pgsql/lib/plpgtest.so
>
> I even tried putting plpgsql.so before it in the list, but no go.

>
>
> Regards,
> Marko Tiikkaja
In this moment, pls, try to use Load plpgsql

I though about it this morning - we should to move plugin registration to core - it should to work like ddl loader

a) it can solve problems with loading
b) it can be usable for all PL environment.

Pavel

 

Regards

pavel


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: gaussian distribution pgbench
Next
From: Etsuro Fujita
Date:
Subject: Re: Rowcounts marked by create_foreignscan_path()