Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?
Date
Msg-id 0A3221C70F24FB45833433255569204D1F59C93D@G01JPEXMBYT05
Whole thread Raw
In response to Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Michael Paquier
> On Fri, Jul 1, 2016 at 10:35 AM, Tsunakawa, Takayuki
> <tsunakawa.takay@jp.fujitsu.com> wrote:
> > I'd like to document the policy clearly in the upgrade section of
> PostgreSQL manual, eliminating any ambiguity, so that users can determine
> what they should do without fear like "may or may not work".  Which of the
> following policies should I base on?
> >
> > Option 1:
> > Rebuild UDFs with the target PostgreSQL distribution and minor release.
> >
> > Option 2:
> > Rebuild UDFs with the target PostgreSQL distribution.
> > You do not have to rebuild UDFs when you upgrade or downgrade the
> > minor release.  (If your UDF doesn't work after changing the minor
> > release, it's the bug of PostgreSQL.  You can report it to
> > pgsql-bugs.)
> 
> That would not be a bug of PostgreSQL, the terms are incorrect. If there
> is an API breakage, the extension needs to keep up in this case, so it would
> be better to mention asking on the lists what may have gone wrong.

OK, I understood that your choice is option 2.  And the UDF developer should report the problem and ask for its reason
onpgsql-bugs, possibly end up haveing to rebuild the UDF.  But if so, it sounds like option 1.  That is, "For safety,
rebuildyour UDF with each minor release.  That way, you can avoid severe problems that might take time to pop up above
water." I wonder if this is similar to the Linux's loadable kernel modules.
 

I'd like to hear opinions from other decision makers here before proceeding, as well as Michael.


Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?
Next
From: Michael Paquier
Date:
Subject: Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions?