Re: PLPGSQL/EXCEPTION HANDLING

From: "renneyt(at)yahoo(dot)com" <renneyt(at)yahoo(dot)com>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: postgres <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PLPGSQL/EXCEPTION HANDLING
Date: 2006-06-13 13:56:26
Message-ID: 448EC40A.5020102@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jaime Casanova wrote:
> On 6/12/06, renneyt(at)yahoo(dot)com <renneyt(at)yahoo(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message renneyt@yahoo.com 2006-06-13 20:28:47 Re: pg_dump/restore problem
Previous Message Jaime Casanova 2006-06-13 05:10:38 Re: PLPGSQL/EXCEPTION HANDLING