The documentation states "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."
Our application developers would like to get back a simple code ( a number) for any error that indicates what it is, and possibly a message. So, as we would with Oracle we wanted to code in exception handlers to do this, but the documenation has us concerned. Is putting exception handlers into the pgsql code really a big performance hit?
Thanks,