Re: PLPGSQL/EXCEPTION HANDLING - Mailing list pgsql-admin

From renneyt@yahoo.com
Subject Re: PLPGSQL/EXCEPTION HANDLING
Date
Msg-id 448EC40A.5020102@yahoo.com
Whole thread Raw
In response to Re: PLPGSQL/EXCEPTION HANDLING  ("Jaime Casanova" <systemguards@gmail.com>)
Responses Re: PLPGSQL/EXCEPTION HANDLING  ("Jaime Casanova" <systemguards@gmail.com>)
List pgsql-admin
Jaime Casanova wrote:
> On 6/12/06, renneyt@yahoo.com <renneyt@yahoo.com> wrote:
>> In a function implemented in 7.4.8 I had the following error when I call
>> the function:
>>
>> ERROR:  syntax error at or near "EXCEPTION"
>>
>> Offending line is:
>>     EXCEPTION WHEN dup_val_on_index THEN NULL;
>>
>> When this line is removed, all is well.
>>
>
> that's because that construction was added in 8.0, you have to upgrade
> to use it
>
What part of the original  construction is  not supported?
Are any "exception when" statements supported?

Thanks

pgsql-admin by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: PLPGSQL/EXCEPTION HANDLING
Next
From: "renneyt@yahoo.com"
Date:
Subject: Re: pg_dump/restore problem