Functions and transactions

From: Giorgio Valoti <giorgio_v(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Functions and transactions
Date: 2008-04-08 13:44:47
Message-ID: 04CC94F9-A558-4A7F-B02B-A84A71B2C23E@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all, the documentation says that functions are always executed
within the transaction established by the outer query. However, I was
quite surprised (in a positive way, that is) seeing that if a
function call causes some error, the whole function is "rolled back".
Is this the expected behavior?

Thank you
--
Giorgio Valoti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zdenek Kotala 2008-04-08 13:47:30 Re: "too many trigger records found for relation xyz"
Previous Message paul tilles 2008-04-08 13:40:17 ecpg-timestamp- interval problem V8.2.x