[BUGS] BUG #1655: trapping errors doesn't work

#1

The following bug has been logged online:

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

while executing:

Quote:

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:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#2

"Emanuel Brokmann" <brokmann.emanuel (AT) ava (DOT) de> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] BUG #1655: trapping errors doesn't work

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] BUG #1655: trapping errors doesn't work - 05-09-2005 , 03:31 PM

Re: [BUGS] BUG #1655: trapping errors doesn't work - 05-09-2005 , 04:02 PM