On Fri, Apr 22, 2011 at 3:50 PM, Tom Lane <[email protected]> wrote: > Merlin Moncure <[email protected]> writes: >> On Fri, Apr 22, 2011 at 1:28 PM, Peter Eisentraut <[email protected]> wrote: >>> It would probably be more reasonable and feasible to have a setup where >>> you can end a transaction in plpgsql but a new one would start right >>> away. > >> ya, that's an idea. > > Yeah, that's a good thought. Then we'd have a very well-defined > collection of state that had to be preserved through such an operation, > ie, the variable values and control state of the SP. It also gets rid > of the feeling that you ought not be in a transaction when you enter > the SP.
hm, another neat thing about this is that it skirts the unfortunate confusion between sql 'begin' and plpgsql 'begin'... merlin -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
