Postgres Pro
Downloads
Home   >   mailing lists

Re: duplicate key violates unique constraint - Mailing list pgsql-sql

From Rodrigo E. De León Plicet
Subject Re: duplicate key violates unique constraint
Date
Msg-id a55915760802260909n1c1f4cd2i18fb56ccafa96d83@mail.gmail.com
Whole thread Raw
In response to Re: duplicate key violates unique constraint  ("Shavonne Marietta Wijesinghe" <shavonne.marietta@studioform.it>)
List pgsql-sql
Tree view 
On Tue, Feb 26, 2008 at 11:36 AM, Shavonne Marietta Wijesinghe
<shavonne.marietta@studioform.it> wrote:
>     BEGIN
>         SAVEPOINT s1;
>         ... code here ...
>     EXCEPTION
>         WHEN ... THEN
>             ROLLBACK TO s1;
>             ... code here ...
>         WHEN ... THEN
>             ROLLBACK TO s1;
>             ... code here ...
>     END;

PostgreSQL doesn't have anonymous blocks.

You need to write a function.

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: duplicate key violates unique constraint
Next
From: "Professor Flávio Brito"
Date:
Subject: Re: Function returns error (view)