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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
