Re: BUG #1655: trapping errors doesn't work

"Emanuel Brokmann" <brokmann.emanuel@ava.de> writes:
> while executing:

> >>BEGIN
> >>  insert into comlineprintboxen VALUES(109, '', '', '', >>'', '');
> >>EXCEPTION
> >>  WHEN unique_violation then
> >>    UPDATE comlineprintboxen SET verteiler='', >>panel='', dose='',
> switch='', port='' WHERE >>printboxid=109
> >>END;

> the following error occurs:

> >>ERROR:  syntax error at or near "UPDATE" at character 8

> i compared the command with the one from page 550 ff of the documentation,
> but can't find differences.

> Would be kind of you to help me

Can't help much with such an incomplete, mangled view of the problem :-(
You need to show us the full text of the CREATE FUNCTION command,
without random characters interspersed due to sloppy cut-and-paste.

            regards, tom lane