Basically, answer is: you can't do it, no matter how you slice it, for a simple reason: postgres doesn't support nested transactions [yet?]. On Sun, 28 Jan 2001, Alan Turner wrote: > Hi > > I've been searching the web/mailing lists/web boards for the answer to a > question I have regarding postgresql. So far, I haven't found a conclusive > answer. My apologies in advance if this is a FAQ/stupid question. > > My problem is that I would like to write a plpgsql procedure that starts and > ends transactions. This requires use of the postgres keyword 'begin'. From > what I can see, the plpgsql parser is wrongly interpreting the begin as a > plpgsql keyword. > > I considered the idea of creating an 'sql' language stored procedure, called > say begin_work() which in turn makes the 'begin work' statement. While this > does seem to work, it seems a bit rediculous. > > I'm hoping that I've been stupid and missed something obvious :-) > > If someone could point me in the direction of the correct documentation, > I'd be most grateful. > > Thanks! > > Cheers, > Alan > > > >
