Re: How to control which Python interpreter Postgres uses?

Apologies if I'm misunderstanding, but you can specify a virtual env (so
any interpreter) as we did here:

CREATE FUNCTION slack (msg text)
RETURNS boolean
AS $$
hook = 'https://...'
activate_this = '/opt/python/env/bin/activate_this.py'
exec(open(activate_this).read(), dict(__file__=activate_this))
from slack_sdk.webhook import WebhookClient
import ssl
ssl_context = ssl.create_default_context()
ssl_context.check_hostname = False
ssl_context.verify_mode = ssl.CERT_NONE
webhook = WebhookClient(hook, ssl=ssl_context)
webhook.send(text=msg)
return True
$$ LANGUAGE plpython3u;

On Mon, Nov 1, 2021 at 3:06 PM Ni Ne <nineoften(at)hotmail(dot)com> wrote:

> Would I recompile the plpython package or postgres itself?
>
> ------------------------------
> *From:* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> *Sent:* Monday, November 1, 2021 4:03 PM
> *To:* Ni Ne <nineoften(at)hotmail(dot)com>
> *Cc:* pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject:* Re: How to control which Python interpreter Postgres uses?
>
> Ni Ne <nineoften(at)hotmail(dot)com> writes:
> > How can I adjust my postgres settings to tell it which Python
> interpreter binary to use?
>
> You'd have to recompile plpython against the particular libpython
> you want to use.
>
> regards, tom lane
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>