"dmarmur2002" <arbit@...> wrote:

>
> I have a unique index on a field marked to take NULL values. I can
> insert multiple records in this table with or without specifying NULL
> in the VALUES "clause".
>
> But with two connections and each using Read Committed i get a Lock
> Conflict if the first transaction is posted but not committed.

This is a known bug, fixed in v2.0.
http://sourceforge.net/tracker/index.php?func=detail&aid=957280&group_id=902
8&atid=109028


Dmitry