Quick Links

Re: Advice request : simultaneous function/data updates on many databases

From:	"David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To:	Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc:	Guyren Howe <guyren(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Advice request : simultaneous function/data updates on many databases
Date:	2020-03-04 22:55:25
Message-ID:	CAKFQuwZ8DCJu9BYckq3AocCP3rkX-g=VvDLON2qnisBnOgofxQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

On Wed, Mar 4, 2020 at 3:48 PM Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
wrote:

> Any thoughts on how to wrap pl/pgsql function dropping and recreation code
> within a wrapper pl/pgsql function?

Not endorsing this but dynamic SQL works just fine (though can get hard to
read). Use format() and EXECUTE ... USING liberally.

CREATE FUNCTION perform_update()...
AS $outer$
BEGIN

drop_sql := $inner$ DROP FUNCTION ...; $inner$
EXECUTE drop_sql;

END;
$outer$;

David J.

	From	Date	Subject
Next Message	David G. Johnston	2020-03-04 22:58:01	Re: Advice request : simultaneous function/data updates on many databases
Previous Message	Rory Campbell-Lange	2020-03-04 22:48:43	Re: Advice request : simultaneous function/data updates on many databases