Peter Eisentraut wrote:
> Greg Stark wrote:
> > One thing to think about, what will the command to execute stored
> > procedures look like? Those will also need to be called from outside
> > a transaction.
>
> Huh? Only if you invent your own stored-procedure theory or have a
> hitherto unknown interpretation of the SQL standard.
We've discussed a couple of times that stored procedures should have
enough abilities to start and commit transactions on their own, to be
useful to administration tasks like vacuuming. It's not something that
has been set in stone but it's something to consider.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support