PLPGSQL/EXCEPTION HANDLING

From: "renneyt(at)yahoo(dot)com" <renneyt(at)yahoo(dot)com>
To: postgres <pgsql-admin(at)postgresql(dot)org>
Subject: PLPGSQL/EXCEPTION HANDLING
Date: 2006-06-13 04:55:25
Message-ID: 448E453D.3080207@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Any help appreciated...

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2006-06-13 05:10:38 Re: PLPGSQL/EXCEPTION HANDLING
Previous Message Jim C. Nasby 2006-06-12 20:56:30 Re: pg_dump/restore problem