Re: [GENERAL] Transactions in user defined function

2009-03-13 Thread Tino Wildenhain
Grzegorz Jaśkiewicz wrote: On Fri, Mar 13, 2009 at 12:03 PM, Jasid ZA 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 brea

Re: [GENERAL] Transactions in user defined function

2009-03-13 Thread Tino Wildenhain
Jasid ZA wrote: Hi, Can we use sql transaction(BEGIN, COMMIT, REVOKE) inside a user defined function in Postgresql 8.3? Would that part of the documentation help? http://www.postgresql.org/docs/8.3/interactive/plpgsql-structure.html "Functions and trigger procedures are always executed with

Re: [GENERAL] Transactions in user defined function

2009-03-13 Thread Grzegorz Jaśkiewicz
On Fri, Mar 13, 2009 at 12:03 PM, Jasid ZA 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 que

[GENERAL] Transactions in user defined function

2009-03-13 Thread Jasid ZA
Hi, Can we use sql transaction(BEGIN, COMMIT, REVOKE) inside a user defined function in Postgresql 8.3? looking forward to hear from you Thanks -Jasid- -- With warm regards Jasid Z. A +91 9946109809