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(at)gmail(dot)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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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