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

"Emanuel Brokmann" <brokmann(dot)emanuel(at)ava(dot)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