Hello
This is not bug
keyword EXCEPTION is supported only in plpgsql.
Regards
Pavel Stehule
2012/7/9 <chine.bleu@yahoo.com>:
> The following bug has been logged on the website:
>
> Bug reference: 6724
> Logged by: Chine Bleu
> Email address: chine.bleu@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