Re: [SQL] transactions within stored procedures

2000-07-14 Thread Thomas Mack
> >By trial and error I established that a SP wraps everything it does in >one transaction, including anything from stored procedures it calls. > >So here is my question: Is there any way for me to control when >transactions are committed or rolled back within stored procedures? Is When you inv

[SQL] transactions within stored procedures

2000-07-14 Thread Nathan Young
Hi. Please correct me if this is off topic for the group. On looking through the available postgres mailing lists, this seemed the most appropriate for my question. Transactions are important to my application. I was scripting in perl with autocommit turned off, issuing commits when appropriat