BUG #1655: trapping errors doesn't work

The following bug has been logged online:

Bug reference:      1655
Logged by:          Emanuel Brokmann
Email address:      brokmann.emanuel@ava.de
PostgreSQL version: 8.0
Operating system:   Red Hat Linux 3.2.3-42
Description:        trapping errors doesn't work
Details:

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


Emanuel Brokmann