Hello This is not bug
keyword EXCEPTION is supported only in plpgsql. Regards Pavel Stehule 2012/7/9 <chine.b...@yahoo.com>: > 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
