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 1reUy3-00BfHY-Bv for pgsql-odbc@arkaria.postgresql.org; Mon, 26 Feb 2024 07:00:04 +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 1reUy2-00Azp6-1H for pgsql-odbc@arkaria.postgresql.org; Mon, 26 Feb 2024 07:00:02 +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 1reUy1-00Azoy-Pt for pgsql-odbc@lists.postgresql.org; Mon, 26 Feb 2024 07:00:02 +0000 Received: from mail-pg1-x52b.google.com ([2607:f8b0:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1reUxz-0014no-Gp for pgsql-odbc@lists.postgresql.org; Mon, 26 Feb 2024 07:00:01 +0000 Received: by mail-pg1-x52b.google.com with SMTP id 41be03b00d2f7-5cedfc32250so2682157a12.0 for ; Sun, 25 Feb 2024 22:59:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=technest.es; s=gkey; t=1708930797; x=1709535597; darn=lists.postgresql.org; h=to:date:message-id:subject:mime-version:from:from:to:cc:subject :date:message-id:reply-to; bh=6dFDVqlmK+7WaVZVAz13sotltMhWL7uySTmwUsl6Cr4=; b=eUj1OfDRaDgeVdsc7Vt4DCvMqysJAtQv+MMUIBzXxeVJ1XQZxiWuTqyctLIlQDdVHg gee+j6YUjGxktg1f5sBn+490hT5U1b8b3+mUj4467abLzENN8rlobkalwxgG271J1BkL ilAfMFMCEVO92wyIWEFY3YEkk77OqtHMhuL0FvOYCVr5MryftIA1+VmXI29wAzTqN0YP CQ58hPOVcaItKgPYr13p1j/lFiIscJPGDatfH9MWHCbAIubWv9viVg76fknnZeFtkhDb xYSF6CScd74xHpi4nYeMHkg2Ce1o24tfIbTyyjjop4LA2igs4IVp89yWHyYaszgqIy72 +m5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1708930797; x=1709535597; h=to:date:message-id:subject:mime-version:from:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=6dFDVqlmK+7WaVZVAz13sotltMhWL7uySTmwUsl6Cr4=; b=tzx7qhrL2vmqAxR+O4PTMP5TCgPYLu3TR+4Yjeu+0xOc39AXDEImlsexk5UwL5KH1S DNRPHpK4lJBxljVhjryC5D8hIoxGzIlZK88XFfMG9RkFbpoAhXld5HLhOdMQGTZSk/+0 B16I1R159oZPu551Oq71mhWjSK0rlhY4dwp3DDkuM4g2SPFbn0pEbaQvbY4gl+jyip6m PSb5XcBBY1wbN1Syc2YemX9Kv34Q/3CL/yGHRCH83S+diwULEGjcA/5v8csluyHbCqYT WJUZemImrNazfYDwSi7ytokPyQCM39/FXiRXQBnnu8uQs5ynzkmPdhtIFoMnuVSYGKZY ZJCg== X-Gm-Message-State: AOJu0YzrD5cbHKvFAFzsxep7cEpvDylKltCXKJ3E3qWs724YZQtJ6qXD E5O1m7OmZbncGRJs3S/CsZ36Szf7xUNS5fHnjSz5on8gOYCvsojhf0rYaOSOdWDhkoh3ECpiD0t 7 X-Google-Smtp-Source: AGHT+IEcNDJaClxDU7KHECgPhiZOZz3aPb9Te4umgVpxiW+2Awo27eowu7dul53JQ1zjNMpFsYh9Tg== X-Received: by 2002:a17:902:8c97:b0:1dc:6c33:df8b with SMTP id t23-20020a1709028c9700b001dc6c33df8bmr5604398plo.13.1708930797266; Sun, 25 Feb 2024 22:59:57 -0800 (PST) Received: from smtpclient.apple (122-116-227-136.hinet-ip.hinet.net. [122.116.227.136]) by smtp.gmail.com with ESMTPSA id y4-20020a170902ed4400b001db5fc51d71sm3206203plb.160.2024.02.25.22.59.55 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 25 Feb 2024 22:59:56 -0800 (PST) From: Alexander Yi Content-Type: multipart/signed; boundary="Apple-Mail=_C4CB419D-10F6-418E-8DCC-B0D7FF70D953"; protocol="application/pgp-signature"; micalg=pgp-sha256 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\)) Subject: Use Postgres ODBC in MacOS's Microsoft Office Excel Message-Id: <966DD21C-C1D0-44F6-81E3-19CC4F4AE9E9@technest.es> Date: Mon, 26 Feb 2024 14:59:53 +0800 To: pgsql-odbc@lists.postgresql.org X-Mailer: Apple Mail (2.3731.700.6) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_C4CB419D-10F6-418E-8DCC-B0D7FF70D953 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Dear supporters in the community, Recently I was working on invoking PGSQL query at MS Excel installed in = MacOS, but I failed to achieve iot due to an issue, which is the sandbox mechanism in MacOS that block the dynamic library = access located in other directory. So I believe the only way to make it work is to build my own Postgres = ODBC, which make my Postgres ODBC have static libpq library, instead of = dynamically accessing it from some path like = /usr/local/opt/libpq/lib/libpq.5.dylib Actually I'm not sure if this is a correct solution or not, and I got no = clue to achieve my hypothetical approach. So hope I can seek some advice here, Thanks for reading my question. BR. Yi --Apple-Mail=_C4CB419D-10F6-418E-8DCC-B0D7FF70D953 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE2Z6wGrauJw0KT1ItbgEuDjSVmWkFAmXcNukACgkQbgEuDjSV mWnHaA/+J7E+su30FqOUBemkLTw64JJ6xZrs1Pwlcs3a6kqIjXRsVfslTKg4JVk+ qR26UD9LC31xOvyYWu177q/zuE5uafmJZKl0NMl7mcc/sfPmhIfoU/78FArsB/bH RTOL7hiB2u70XxEWLOXLcAp93Lvvh9GfRelhHp6ow5dohRBDfyomK+HW4X0yPG+0 I+rb5N5Umg7BZZFImt5yn1zmUydi+D7Uq65D6YsPOJc2kMjhSiUAac2kDny2eOv6 3hLKbwCbajQoz6qzwGfqTLgCKihgmu3odtaiKKoIEX51jUgBuOJyTQekFvnuYqMH hbgFwYJR+x0IPHHIU89f/SjC1Twq1C5j4LOPyoulCkWzTLcSixjZQycNnc0H1Fda lgkcg9I5Tye5yVLp5h/Rtan9qhAiwl+oIiLLDXZ3LiEeWkBr82Oubygyqmz9lqMO KPz/AQh2cFLgcl+vmAxNdPKQJ7w7vvn2b2m8gZiA4ldG8WDXRsLT+ZweJZv5hnZm N6KBQ8nKwuibfr/+VS+kixGKcpgFgf04GNSLMysxZFdJjYiBp+08+MwhRU6ZtP/y Pd/CMl4PaPYG/MRAWHF3eXP/ZVZ39TxveAGbga2sD2uTmM0t1jIou56mRi2pkvdv fzrYMnTOWNPKYVdSqYXniYRxTgTw0HsS4/lsyKhkjhTm9j3/C48= =UMW6 -----END PGP SIGNATURE----- --Apple-Mail=_C4CB419D-10F6-418E-8DCC-B0D7FF70D953--