Re: proposal, patch: allow multiple plpgsql plugins

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