Postgres Pro
Downloads
Home   >   mailing lists

PLPGSQL/EXCEPTION HANDLING - Mailing list pgsql-admin

From renneyt@yahoo.com
Subject PLPGSQL/EXCEPTION HANDLING
Date
Msg-id 448E453D.3080207@yahoo.com
Whole thread Raw
Responses Re: PLPGSQL/EXCEPTION HANDLING  ("Jaime Casanova" <systemguards@gmail.com>)
List pgsql-admin
Tree view 
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...

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: pg_dump/restore problem
Next
From: "Jaime Casanova"
Date:
Subject: Re: PLPGSQL/EXCEPTION HANDLING