Re: EXCEPTION in pl/pgsql

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: EXCEPTION in pl/pgsql
Date: 2005-07-19 19:10:43
Message-ID: 42dd4943$0$3624$8fe63b2a@news.disputo.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19.07.2005 20:56, Craig Bryden wrote:
> What is the syntax if I want to use the exception clause in a pl/pgsql
> function, but am not looking for a particular error. Kind of like a "any
> error" type thing.
>

35.7.5. Trapping Errors
http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

"The special condition name OTHERS matches every error type except
QUERY_CANCELED."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kelvin T. Leung 2005-07-19 19:47:38 psql: error while loading shared libraries: psql: undefined symbol: get_progname
Previous Message Craig Bryden 2005-07-19 18:56:04 EXCEPTION in pl/pgsql