BUG #1655: trapping errors doesn't work

Started by Emanuel Brokmannalmost 21 years ago2 messagesbugs
Jump to latest
#1Emanuel Brokmann
brokmann.emanuel@ava.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Emanuel Brokmann (#1)
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