On Tue, Apr 19, 2011 at 12:27:45PM -0400, Christopher Browne wrote: > On Tue, Apr 19, 2011 at 12:22 PM, Robert Haas <robertmh...@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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers