On 2012-01-09, 邓尧 <torshie@xxxxxxxxx> wrote: > insert into ACCOUNT(HOME) > select "v1" as HOME > where not exists (select 1 from ACCOUNT where HOME =3D "v1") > > Surprisingly, I still got the unique constraint violation error, but much > fewer than before ( only 3 during the last 3 days). > Any suggestions? Could it be a bug in psycopg2 or postgresql? No bug, that's ecpected behavior (unless you switch to serializable isolation level) when I need to insert if missing and need to avoid all errors I write it like above but wrap it in a plpgsql function with an exception clause to handle the error. -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
