Thread: 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

"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