Re: plpgsql_check_function - rebase for 9.3

From: "Petr Jelinek" <pjmodos(at)pjmodos(dot)net>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'Pavel Stehule'" <pavel(dot)stehule(at)gmail(dot)com>, "'PostgreSQL Hackers'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plpgsql_check_function - rebase for 9.3
Date: 2013-01-26 23:41:40
Message-ID: 001601cdfc1e$b1348500$139d8f00$@pjmodos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 26 January 2013 20:12
> Subject: Re: [HACKERS] plpgsql_check_function - rebase for 9.3
>
> I wrote:
> > [ pokes around... ] Hm, it appears that that does work on Linux,
> > because for some reason we're specifying RTLD_GLOBAL to dlopen().
> > TBH that seems like a truly horrid idea that we should reconsider.
>
> A bit of research in the archives revealed that we're using it because
back in
> 2001, the lame hack that then passed for a shared-library version of
python
> required it:
> http://www.postgresql.org/message-id/Pine.LNX.4.30.0105121914200.757-
> 100000(at)peter(dot)localdomain
>
> There was subsequent discussion of removing it, because reportedly now
> (a) that's no longer the case, and (b) we need to get rid of it to allow
> plpython2 and plpython3 to coexist in one session. See for instance:
> http://www.postgresql.org/message-
> id/1277506674(dot)5356(dot)27(dot)camel(at)vanquo(dot)pezone(dot)net
>
> Nothing's been done about that yet, but I think that assuming that we'll
be
> using RTLD_GLOBAL forever would be foolish.
>

Ok then it was a bad idea after all.

Regards
Petr

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-01-26 23:47:32 Re: Proposal for Allow postgresql.conf values to be changed via SQL [review]
Previous Message Craig Ringer 2013-01-26 23:38:11 Re: Strange Windows problem, lock_timeout test request