Re: pgbench \for or similar loop - Mailing list pgsql-hackers

From Christopher Browne
Subject Re: pgbench \for or similar loop
Date
Msg-id BANLkTik6V06qqVq5ok3zBXZbdMG2ym-zgg@mail.gmail.com
Whole thread Raw
In response to Re: pgbench \for or similar loop  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: pgbench \for or similar loop  (Robert Haas <robertmhaas@gmail.com>)
Re: pgbench \for or similar loop  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Tue, Apr 19, 2011 at 12:22 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Yeah.  I was wondering if anyone was gung-ho enough about this to
> implement some kind of library that both programs could draw on.
>
> It probably wouldn't be super-hard, if we could agree on a rough design.

It seems to me that the Mo Betta answer would be to implement the
fabled "stored procedure" language, that has, as its distinctive, the
capability to control transactions.  That would have the capability of
being used in places other than just inside psql.

And it would be a good way for scripting things like specialized
vacuum and analyze regimens, which cannot be done inside stored
functions today.
--
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgbench \for or similar loop
Next
From: Tom Lane
Date:
Subject: Re: [JDBC] JDBC connections to 9.1