Re: Access to dynamic SQL in PL/pgSQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Access to dynamic SQL in PL/pgSQL
Date
Msg-id 2208.1264178017@sss.pgh.pa.us
Whole thread Raw
In response to Re: Access to dynamic SQL in PL/pgSQL  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Access to dynamic SQL in PL/pgSQL  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> Anyway, there already was another way of doing this, so it shall be done
> that way instead. The beauty of a pluggable architecture is that one
> does not need approval to implement customer solutions.

If you're talking about a bundle that you're shipping to customers,
of course you can do whatever you want, since you can ensure that
your plpgsql.so and your plugin are compatible.  Stuff we release
into the wide world doesn't have that luxury.  We can't assume much
more than what PG_MODULE_MAGIC will enforce for us, and that means
ABI breaks within a major release series are dangerous.

But to get back to the point, what have you got against adding
another plugin call within the statements that build dynamic
queries?  It seems like a much cleaner solution to me, and not
any different from the standpoint of back-portability.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: commit fests (was Re: primary key error message)
Next
From: Andrew Dunstan
Date:
Subject: Re: warn in plperl logs as... NOTICE??