I wrote the query in the SQL windows provided by the pgadmin.
According to the examples in "Chapter 35. PL/pgSQL - SQL Procedural
Language" i don't see what i did different.
BEGIN
SAVEPOINT s1;
... code here ...
EXCEPTION
WHEN ... THEN
ROLLBACK TO s1;
... code here ...
WHEN ... THEN
ROLLBACK TO s1;
... code here ...
END;
Maybe missing tabs before the statement??
Shavonne
----- Original Message -----
From: "Teemu Torma" <[EMAIL PROTECTED]>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, February 26, 2008 5:28 PM
Subject: Re: [SQL] duplicate key violates unique constraint
On Tuesday 26 February 2008, Andrew Sullivan wrote:
Well, except that there's no "EXCEPTION" statement in SQL? Â I think
your correspondent was intending for this to be programmatic.
I was thinking pl/pgsql.
Teemu
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
