On Fri, Apr 22, 2011 at 3:50 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Merlin Moncure <mmonc...@gmail.com> writes: >> On Fri, Apr 22, 2011 at 1:28 PM, Peter Eisentraut <pete...@gmx.net> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
