Re: proposal, patch: allow multiple plpgsql plugins

2014-03-03 6:09 GMT+01:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:

>
> Dne 2. 3. 2014 21:55 "Marko Tiikkaja" <marko(at)joh(dot)to> napsal(a):
>
> >
> > On 3/2/14, 8:47 PM, Pavel Stehule wrote:
> >>
> >> 2014-03-02 19:59 GMT+01:00 Marko Tiikkaja <marko(at)joh(dot)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
>