On 2012-01-09, 邓尧 <tors...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
