Re: Pgxs - How to reference another extension

> On 11 Mar 2024, at 15:00, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
>
> The advantage of OidFunctionCall is fact, it is working on MacOS. My extension plpgsql_check has a lot of dependencies on plpgsql.
>
> The linking on MacOS required special section in Makefile
>
> ifeq ($(PORTNAME), darwin)
> override CFLAGS += -undefined dynamic_lookup
> endif

Thanks! That worked (I am on MacOS indeed).

>
> And there was another problem with loading dependencies.

Right - the problem seems to be:
ERROR: could not load library "/opt/homebrew/opt/postgresql(at)16/lib/postgresql/btree_gist_extra.dylib": dlopen(/opt/homebrew/opt/postgresql(at)16/lib/postgresql/btree_gist_extra.dylib, 0x000A): symbol not found in flat namespace '_gbt_text_consistent'

That only happens when btree_gist is _already_ loaded earlier.

When btree_gist is not loaded yet and I perform:

CREATE EXTENSION btree_gist_extra CASCADE;

all works fine.

> So now, I use only indirect methods.

I would like to avoid it but maybe it is going to be necessary.

BTW - the extension is https://github.com/mkleczek/btree_gist_extra

Thanks!

—
Michal