Transactions inside plpgsql?
От | Alan Turner |
---|---|
Тема | Transactions inside plpgsql? |
Дата | |
Msg-id | 200101280525.QAA20743@freddy.localdomain обсуждение исходный текст |
Ответы |
Re: Transactions inside plpgsql?
|
Список | pgsql-general |
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 -- ----------------------------------------------------------------------------- Alan Turner | Voice: (02) 9481 8223 | Email: alan@suburbia.com.au ----------------------------------------------------------------------------- Encrypted mail welcome. | Key: http://homepages.tig.com.au/~aturner/alan.gpg 1024D/9F513D15 1999-09-16 Alan Turner <alan@suburbia.com.au> Key fingerprint = 2CC3 CDB9 7BE2 0585 EA63 19A1 C4EC EA32 9F51 3D15 ----------------------------------------------------------------------------- To see a need and wait to be asked, is to already refuse. ----------------------------------------------------------------------------- --FAA06171.980657327/dshmail1.dsh.de-- -- ----------------------------------------------------------------------------- Alan Turner | Voice: (02) 9481 8223 | Email: alan@suburbia.com.au ----------------------------------------------------------------------------- Encrypted mail welcome. | Key: http://homepages.tig.com.au/~aturner/alan.gpg 1024D/9F513D15 1999-09-16 Alan Turner <alan@suburbia.com.au> Key fingerprint = 2CC3 CDB9 7BE2 0585 EA63 19A1 C4EC EA32 9F51 3D15 ----------------------------------------------------------------------------- To see a need and wait to be asked, is to already refuse. -----------------------------------------------------------------------------
В списке pgsql-general по дате отправления: