From: | "Shavonne Marietta Wijesinghe" <shavonne(dot)marietta(at)studioform(dot)it> |
---|---|
To: | "Teemu Torma" <teemu(at)torma(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: duplicate key violates unique constraint |
Date: | 2008-02-26 16:36:09 |
Message-ID: | 017901c87895$b1782380$3102a8c0@dream |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Wetherbee | 2008-02-26 16:36:51 | Re: Function returns error (view) |
Previous Message | Bart Degryse | 2008-02-26 16:34:33 | Re: duplicate key violates unique constraint |