W dniu 22 września 2011 08:11 użytkownik Amar Dhole napisał:
> **
>
> Hi Filip,
>
> ** **
>
> No not sure 100% when this can happen. This approach will not be possible
> as in our application we are programmatically handling these cases and going
> in other route to add the record with increas
: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Filip Rembialkowski
Sent: 21 September 2011 20:37
To: Amar Dhole
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] handling duplicate row exception
Hi
There is no IGNORE_DUP_KEY equivalent in PostgreSQL.
If you are
Hi
There is no IGNORE_DUP_KEY equivalent in PostgreSQL.
If you are 100% sure that you want to ignore unique key violations, you can
wrap your INSERT code in PL/PgSQL block and handle the exception yourself.
I mean:
DO $$
BEGIN
INSERT INTO foo (bar,baz) SELECT 42, 666;
EXCEPTION WHEN unique_vio
Hi All,
I have a requirement where my application tries to enter the duplicate row in
table using batchexceute code. And batch exception is thrown we checked error
code and skip it but after this exception all my next update/insert gets error
out with following exception
"Database error. SQL s
