Re: Transaction Handling in pl/pgsql

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
Cc: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Transaction Handling in pl/pgsql
Date: 2005-07-12 18:46:18
Message-ID: m2hdezvp51.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Craig Bryden" <postgresql(at)bryden(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Bryden 2005-07-12 18:54:59 Re: Transaction Handling in pl/pgsql
Previous Message Craig Bryden 2005-07-12 18:44:40 Re: Transaction Handling in pl/pgsql