"Craig Bryden" <postgresql@xxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
