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