The following bug has been logged on the website:
Bug reference: 6724
Logged by: Chine Bleu
Email address: chine.b...@yahoo.com
PostgreSQL version: 9.0.4
Operating system: macosx
Description:
query: BEGIN
INSERT INTO config (name, value) VALUES (E'dbexp', E'10');
EXCEPTION WHEN unique_violation THEN
UPDATE config SET value=E'10' WHERE name=E'dbexp';
END error: fatal query: ERROR: syntax error at or near "INSERT"
LINE 2: INSERT INTO config (name, value) VALUES (E'dbexp', E'10');
^
query: BEGIN;
INSERT INTO config (name, value) VALUES (E'dbexp', E'10');
EXCEPTION WHEN unique_violation THEN
UPDATE config SET value=E'10' WHERE name=E'dbexp';
END error: fatal query: ERROR: syntax error at or near "EXCEPTION"
LINE 3: EXCEPTION WHEN unique_violation THEN
^
This is so much easier than implementing that horror of REPLACE everyone
else has somehow figured out how to implement.
And, no, I don't really expect an answer. I will continue to use the
DELETE...;;INSERT... improvement on REPLACE.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
