Re: duplicate key violates unique constraint

["Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it>]

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(at)torma(dot)org>
To: <pgsql-sql(at)postgresql(dot)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