From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
cc: Riaan Stander <rstander@exa.co.za>,
        "pgsql-performa." <pgsql-performance@postgresql.org>
Subject: Re: Bulk persistence strategy
In-reply-to: 
 <CANP8+jL54J5_i6K3zX9Zm2wGirBbeh1YG0uLXBwARiLjyjenrg@mail.gmail.com>
References: <04c901d2a753$f55de020$e019a060$@exa.co.za>
 <15c29aeedc8.27e1.e05fafc80f8daf1488764675043d44fb@exa.co.za>
 <32403.1495377186@sss.pgh.pa.us>
 <0e47ae52-e80a-fd8e-021c-7c8cc0495b26@exa.co.za>
 <30684.1495406234@sss.pgh.pa.us>
 <de75eb5b-be39-d3f4-ae5f-65d67f53ec59@exa.co.za>
 <CANP8+jL54J5_i6K3zX9Zm2wGirBbeh1YG0uLXBwARiLjyjenrg@mail.gmail.com>
Comments: In-reply-to Simon Riggs <simon@2ndquadrant.com>
	message dated "Mon, 22 May 2017 06:15:26 +0100"
Date: Mon, 22 May 2017 07:50:15 -0400
Message-ID: <64473.1495453815@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Simon Riggs <simon@2ndquadrant.com> writes:
> It sounds like you don't know about anonymous code blocks with DO
> https://www.postgresql.org/docs/devel/static/sql-do.html

No, the problem was that there are also some parameters to be passed
in from the application, and DO doesn't take any parameters; so that
would require inserting them manually into the DO text, with all the
attendant hazards of getting-it-wrong.

We've speculated before about letting DO grow some parameter handling,
but it's not gotten to the top of anyone's to-do list.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance