Re: pgbench \for or similar loop

On Tue, Apr 19, 2011 at 12:27:45PM -0400, Christopher Browne wrote:
> 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.

This seems like a proposal that's evolving toward a long-standing
TODO, namely autonomous transactions.

At the time it was added, it went into the "Exotic Features" section,
which I believe needs extensive reworking, if not outright deletion.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate