Functions and transactions - Mailing list pgsql-general

From Giorgio Valoti
Subject Functions and transactions
Date
Msg-id 04CC94F9-A558-4A7F-B02B-A84A71B2C23E@mac.com
Whole thread Raw
Responses Re: Functions and transactions  (Martijn van Oosterhout <kleptog@svana.org>)
List 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





pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Numbering rows by date
Next
From: Kev
Date:
Subject: Re: drop database regardless of connections