Re: "stored procedures" - use cases? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: "stored procedures" - use cases?
Date
Msg-id 1303758434.5006.64.camel@vanquo.pezone.net
Whole thread Raw
In response to "stored procedures"  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: "stored procedures" - use cases?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: "stored procedures" - use cases?  ("Todd A. Cook" <tcook@blackducksoftware.com>)
Re: "stored procedures" - use cases?  (Merlin Moncure <mmoncure@gmail.com>)
Re: "stored procedures" - use cases?  (Darren Duncan <darren@darrenduncan.net>)
Re: "stored procedures" - use cases?  (Josh Berkus <josh@agliodbs.com>)
Re: "stored procedures" - use cases?  (Daniel Farina <daniel@heroku.com>)
List pgsql-hackers
On tor, 2011-04-21 at 18:24 +0300, Peter Eisentraut wrote:
> So the topic of "real" "stored procedures" came up again.  Meaning a
> function-like object that executes outside of a regular transaction,
> with the ability to start and stop SQL transactions itself.
> 
> I would like to collect some specs on this feature.  So does anyone have
> links to documentation of existing implementations, or their own spec
> writeup?  A lot of people appear to have a very clear idea of this
> concept in their own head, so let's start collecting those.

Another point, as there appear to be diverging camps about
supertransactional stored procedures vs. autonomous transactions, what
would be the actual use cases of any of these features?  Let's collect
some, so we can think of ways to make them work.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unlogged tables, persistent kind
Next
From: Tom Lane
Date:
Subject: Re: Unfriendly handling of pg_hba SSL options with SSL off