On Fri, Mar 13, 2009 at 12:03 PM, Jasid ZA <za.ja...@gmail.com> wrote: > Hi, > > Can we use sql transaction(BEGIN, COMMIT, REVOKE) inside a user defined > function in Postgresql 8.3? > > looking forward to hear from you
Nope. If function does something naughty - do RAISE EXCEPTION, that will break transaction and query (hence rollback). Please notice, that in plpgsql function uses BEGIN and END, and those are precisely there to start and end transaction. You cannot also change transaction level in function, it has to be done on 'upper' level. hth. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
