Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjg6i-0077dd-62 for pgsql-general@arkaria.postgresql.org; Mon, 11 Mar 2024 13:54:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rjg6g-00ELAJ-H2 for pgsql-general@arkaria.postgresql.org; Mon, 11 Mar 2024 13:54:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rjg6f-00ELA9-Sf for pgsql-general@lists.postgresql.org; Mon, 11 Mar 2024 13:54:22 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rjg6a-003wNt-39 for pgsql-general@lists.postgresql.org; Mon, 11 Mar 2024 13:54:18 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-609408d4b31so41868217b3.0 for ; Mon, 11 Mar 2024 06:54:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; t=1710165254; x=1710770054; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:from:to:cc:subject:date:message-id:reply-to; bh=objkFXH6OWNtLd5hwk413BHCzG5OvfIZWn/G+7F1jh4=; b=Pn/W1viTGZC2odnCeg/SLMUcpEKXjZinn40IAfsoe5bgZocoMHyYj5YwXkgAAWwUSk c3yGUc/uVOzQu9GwpsMF89t37ETabJI4Zr7rxM5A2NnV17af1chWkne5FW1KNHGq2nQ8 lwP+tQ2mKm/FiMhQFa3no8/lNZBkbfaG/ytfIuoM7Ybi6TsbEyAC7AE30G6bIHBlMSt/ 3QSfUXfRXiLd50M+8xQLID9iTKooqgAzus1ZKr0GjMHoy6bnoE2TIbZL+gSAmZ+be1cY E0oCrT9vCn+kk2Y80etKZytH3I1C1I9GlgWBt+ZGOnWllC5hzdofG5AmHfVvgaqi/1YW 1/8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710165254; x=1710770054; h=content-transfer-encoding:in-reply-to:autocrypt:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=objkFXH6OWNtLd5hwk413BHCzG5OvfIZWn/G+7F1jh4=; b=YFjiaheENmQ5IeLzLL2Q0ii6kKMbar8z2Hzhyf0p7t16aHXnMAUe3UQ4SLddWGHQDZ 93V2LmqalNVN+JGTmhfqHtPGx4q9/+McdYTCg6AjnGEvlR7l5CYdK2jfGs4VAOz3oNdt BQlUduyRF85pm+EVwU16Ne9E5NEks7IvcGUUn5s+fjnOJQvz8DuNQ0lLSbw9bxzAcbSq UWmf5X13glyUZI0Fn+VivROgl+syFcZInjyXFVaecF6JuHuBfPjHgoU6zMA/hoLU8XJO rO+IrR//m8kIhtT99NDfZ1nZZr0BwAyBiPMlE1Co/RyNMDv/JrJVfSE7LRzIQfGmY8ZO Y0aQ== X-Gm-Message-State: AOJu0YwezX/fHZdGaK4FCDj/L0xpoEI0o0tEMKjGmNeOjtzZUekfDx3u uIXn60fd4Ay72Ixp8IqoftVvctHT24wRrmWwI6Jp03kzT8kFwyJlgJk/YlBNv8s= X-Google-Smtp-Source: AGHT+IGnklDDZtxniezj8PY1bXzi/K/OYRzSC+R8Wt2s4JY9fAvBsWXc6yjKqo7VGrCV/tP0l/roVQ== X-Received: by 2002:a0d:ea49:0:b0:60a:23db:1a07 with SMTP id t70-20020a0dea49000000b0060a23db1a07mr4684061ywe.14.1710165254246; Mon, 11 Mar 2024 06:54:14 -0700 (PDT) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id s77-20020a819b50000000b006079e8f3572sm1342841ywg.85.2024.03.11.06.54.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 11 Mar 2024 06:54:13 -0700 (PDT) Message-ID: <9ce1cb38-fd38-4cd7-bdaf-ac9f910ad4c7@joeconway.com> Date: Mon, 11 Mar 2024 09:52:51 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Pgxs - How to reference another extension To: =?UTF-8?Q?Micha=C5=82_K=C5=82eczek?= , Artur Zakirov Cc: pgsql-general References: <98BD6A59-DD01-4F6B-8468-8C44B8C81878@kleczek.org> <66924398-31C4-40CF-B892-CDE266293439@kleczek.org> Content-Language: en-US From: Joe Conway Autocrypt: addr=mail@joeconway.com; keydata= xsFNBEpXMCsBEADDnXUQzjlyi/cX02Gtdy2CLcroE5CsC7DJKdOBDbfgn0kfiIYoV5JniG4l VyzZUodY8yUAagqLYolh0UkBzs9N+qkm7erde4ypw3jzVQ37BuzIvk3nMUbuDZDgxWqX+nVS sKc+BQ5BpzgCHg48leoRO2ohjvYnUhgH3j2rFZCzaj6qQ7mv+XoxOJmUlVQtG06Jwkk7Vu14 7U9nMMM6hyUKzVnmCphnlcMNo26UyVU70MwFfFJgcI0c5fpp8byN56eD6VJVnufO5WAuEhzE qcrSJR2FAlmM90GBY+6vP29twLDCHuSFvrnujNCx/BvCC/a3/gPvyAFp4JtMm9eXAmq3m/Kw 94nTJXVdcbQeQQDp3KIG7MmWS4lnGvPn8v0CjgNaLvZXFLo1FgmUVsyEq1Lww4iRLa6sbpXJ ESx15UEue1k1YZM9C+4F/o3aeKNsAienjw2EXFzcaxIg/C4P493VMi3Qa8ycVxR5iYhUbYdo DFIUQhbFNsYfrtW/qZAELT3FCYFpZYG01e9Hj+cBrXXgyDDkQ5Lq4mlvmkRvuxn61V6Au4HA 0sJiCox5pM1FvzT+aI8HY1BYaiB9Pl4fhpKgmhhlSuglk9v39S4jmlUIb45iLAUVpeNM6Qjm 69pf5da9sm4aGFa7YlDSKf/WcU7z9ITZxsilOi2n7YJiwG7kTQARAQABzSRKb3NlcGggRSBD b253YXkgPG1haWxAam9lY29ud2F5LmNvbT7CwXoEEwEIACQCGwMCHgECF4AFCwkIBwMFFQoJ CAsFFgIDAQAFAlWTVvUCGQEACgkQMyt+aLaZQ0oPCQ/9HyRewMyvAIJRmoXoLAr8AoFLId6R qBJnNX0Lll0RLZui65aQ0+exwX7aH7TxWR16B2gWX3OmLfGT8XITOoG+zt9zsEpLvNkHchkF T/jyAcbuRj5WX9hamZgMbjXAJeCdlhW+fRA9Upb0w4dgBjqK5OgsqMikASL7t2vogHl9H08j vSoQLW+8wTnSBXBeBTBwB7xLIin5WVivzFHUCrnD2UsjeBIW3fmGdpTAjSxRzG+UPYVwXQ8F FLt7DpEytvLWapmZWMRdj0WZ/Q3SOO/Ed0yFqbzuwKaWcFrQBNeS2Sig+FefBNS98f9Hx7ku H3DW34qX/zSSdDh0jLs7X3PkIgF6BZR2TxaCwHPP9ERDiDaUInC9U7We1iZE1DjW8rLMEVJB hY0ClrrF67pnUKTbcU+uajpPn+2Jl74T0Set/XxpHZ4cezcJuqg31R8vHZgd5cf1WKP0D0pc qiuS02BBFkNCs1jQ+raTWcDuE6F1mUO2nvjUBN9r4y5DUbCNSqLKeAe/aA6JaSDkBpoXKdNS +c4rbzbktWkfUW8EhVlCGzNpy4ezEoVsqV2Ex7fNoxsE2vnSylLT9hycAmYf8ryMvniRZqnD T4JgLenIcQlkhB896T7wApOXfD8OJj1/XFxAfPi6vdlsr81uoxuB4euLp8IyduwLORRUogO9 zmAXG5jOwU0ESlcyJwEQAOkTBb9yDhJbMUgvhM11rZwT5tm4Y9TqtEHn0Zy3t9g7bdFFpMva v/KENd3oAtLFpMDf+H3AggFk4ftUwJwiVgJ88ilvCynJUGXiuYIaexY4DLgn4xpnuiEpYEFV dWnlw7dWVTc62exfqIz9bSWRzwfBCY9ruYGEb4RDPDSNSAVyI7sxHzef2asiYxIcxrTrw5Vu gWNlPZcV5/EJ6PUvATjBF2TBkXV7KOciQng2tsQGrGMkY5mduNqwpuh6zfPcVF8LeObe96wv 5ZhPRpO79nef7hnK2lJogp3JIo558Jlbz9WHtQEMZR85+bUhtI825QyNAFz3Jrn7NMgvDikc 2OrWo7YMgMC5hDSWVFqA6/EQCNnDWGABWgeYHZFpnPwsvUWIYdhSilUuj/Tuzvz9ZmucFNbQ bauDQw6VQ38ofGnoYDZFJsGncprB8dBi4tDrIQ+1RlIh6C2Z/eMipqJOT26+spluTjouvnKT 0S5yOgyX0PjbsysgwQdCGNJLHOjhHbSpSmOLaduV3CQo/0+DHT/TBjYfIXjTWouY9TkGxG4e NrxU0u2xAy5bMqOPmsFdjLTWlQUlF/fTMhB54XwI3FHWgnSnXZzStDTmTebLNdT/ftgliAzA 81uMj49j0exv731/v+7udLA1bV8gnZ01zQCASDpWiRQR3fgwcugSUqgRABEBAAHCwV8EGAEI AAkFAkpXMicCGwwACgkQMyt+aLaZQ0pwAQ//bjcWnZg/jjRQ9gbZUGMqniItZYRglBMKIqt4 Fia379JmHwTvavnFkJ8XMZ56UB0FIrgS+sUkRH6cPRQR+7Qi392LD021DXgSsz9CwFHjFyBG HwLEOTRcfYQbtJy0shHDJB4aQTOX3ERDH1PsvJNuevmQMzS0DWFav9+xMz9rKP4N+HffoBIZ E0C1xIE43nD4eLsbycte9sVIrmlNuUti3qUxJAQw8HwfJ6ZbBInHxquApR16uD1u99o6Xlnd FrDlY22tRmHCM0bR81GfGNdcU3Uo+rG/R/k4qa7s9/dgKvMbyH3fHhp/ceKag80Xo8IFurRl 0ZJP3sHJ2QDHCVLat7jRZ+43hi1WlIhFbrgn6IyI0i7XR/W8JjrC5MsKq4TUwGH077sU/kcH YebVJZRbUUst2hAGHDFVBcG12qoKf+ltL9qXJc1y7BGeCoUW6QjOpljpq6ZL4FQUsM0RSRjs 5egE3szPcIf5SyPK6WDOApoAq6M7BBFMGDZwEylYMtr0YekA1u86UA9D2xwLHEbBBp/uiby1 c9JbPJ1Pn8zJP8WZNeRw4Q9TtqVK09+oLirMUSpIDd6KdZ1VgRxOK2re7tjDvkVuYsSrsiJ+ 1iJNEnp9iK0ok0DlJpSCe6KhkxpaTdeoWMXdKuJWec0NIqoAd54ZgBPnr+UPxTixgPq/p6Q= In-Reply-To: <66924398-31C4-40CF-B892-CDE266293439@kleczek.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/11/24 09:48, Michał Kłeczek wrote: > > >> On 11 Mar 2024, at 14:08, Artur Zakirov wrote: >> >> On Mon, 11 Mar 2024 at 13:26, Michał Kłeczek > > wrote: >>> >>> >>>> On 11 Mar 2024, at 11:41, Michał Kłeczek wrote: >>>> >>>> Hi, >>>> >>>> I am trying to create an extension that delegates some calls to >>>> btree_gist functions: >>>> >>>> DirectFunctionCall5Coll( >>>>               gbt_text_consistent, …other arguments); >>>> >>>> Basic PGXS Makefile does not work - I get linker error: >>>> >>>> Undefined symbols for architecture arm64: >>>> "_gbt_text_consistent", referenced from: >>>> >>>> >>>> Anyone could provide me with some hints? >>> >>> I’ve added: >>> PG_LDFLAGS += -L$(shell $(PG_CONFIG) --pkglibdir) -lbtree_gist >> >> You can try FunctionCall5Coll() or OidFunctionCall5Coll() functions. >> >> OidFunctionCall5Coll() calls fmgr_info() and FunctionCall5Coll(). What >> you only need is Oid of the target function. > > What I am trying to do is wrapping and decoration of gbt_text_consistent > function. > The reason I want to use DirectFunctionCall5Col is that other variants > require catalog lookup > as I don’t have old of the wrapped function. > The lookup itself is problematic as the only piece of information I have > is the strategy number. > What’s more - the result of the lookup should be cached in fn_extra and > that makes things even more complex. > > Is there any way to simply link against another extension library? I used this successfully in the past with postgis: postgis_libdir := $(shell pg_config --pkglibdir) postgis_libver := $(shell ls -1 $(postgis_libdir) | grep "^postgis") SHLIB_LINK += -L$(postgis_libdir) -l:$(postgis_libver) -llwgeom HTH, -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com