Re: duplicate key violates unique constraint

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" <teemu@torma.org>
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