Re: Transaction Handling in pl/pgsql - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Transaction Handling in pl/pgsql
Date
Msg-id m2hdezvp51.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Re: Transaction Handling in pl/pgsql  ("Craig Bryden" <postgresql@bryden.co.za>)
List pgsql-general
"Craig Bryden" <postgresql@bryden.co.za> writes:

> OK. I have read that. The part that sticks out is "A block containing an
> EXCEPTION clause is significantly more expensive to enter and exit than a
> block without one. Therefore, don't use EXCEPTION without need. ".
> Performance is paramount to me.
>
> If I ommit the EXCEPTION clause will all the statements still be rolled back
> if an error occurs?

Yes, if you don't use EXCEPTION clauses the behavior is the same as
previous versions.

-Doug

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Transaction Handling in pl/pgsql
Next
From: "Craig Bryden"
Date:
Subject: Re: Transaction Handling in pl/pgsql