Re: Pgxs - How to reference another extension

От

Michał Kłeczek

Тема

Дата

11 марта 2024 г. в 17:40:47

Msg-id

5D02949C-D905-403A-A01C-413232475E5A@kleczek.org

обсуждение

Ответ на

Re: Pgxs - How to reference another extension (Pavel Stehule)

Список

pgsql-general

Дерево обсуждения

Pgxs - How to reference another extension Michał Kłeczek <michal@kleczek.org> 11 марта 2024 г. в 10:41:19

Re: Pgxs - How to reference another extension Michał Kłeczek <michal@kleczek.org> 11 марта 2024 г. в 12:26:00

Re: Pgxs - How to reference another extension Artur Zakirov <zaartur@gmail.com> 11 марта 2024 г. в 13:08:24

Re: Pgxs - How to reference another extension Michał Kłeczek <michal@kleczek.org> 11 марта 2024 г. в 13:48:23

Re: Pgxs - How to reference another extension Joe Conway <mail@joeconway.com> 11 марта 2024 г. в 13:52:51

Re: Pgxs - How to reference another extension Pavel Stehule <pavel.stehule@gmail.com> 11 марта 2024 г. в 14:00:15

Re: Pgxs - How to reference another extension Michał Kłeczek <michal@kleczek.org> 11 марта 2024 г. в 17:40:47

On 11 Mar 2024, at 15:00, Pavel Stehule <pavel.stehule@gmail.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@16/lib/postgresql/btree_gist_extra.dylib": dlopen(/opt/homebrew/opt/postgresql@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.