Subject Re: 2 identical record inserts not stopped by UNIQUE constraint
Author Stan
--- In, "Ann W. Harrison"
<aharrison@...> wrote:
> Stan wrote:
> >
> > I open a new isql session and I see the 2 records.
> Then it's a different problem. Can you cause it to
> happen using just that procedure - meaning that no one
> is deleting or updating records concurrently?

This is the first time this happened in about a year of testing.
So I dont think that I will be able to reproduce it.

When this happened, no records were being deleted or updated.
Only insertions and selects using this procedure are occuring
from up to 200 concurrent transactions.

> big is the database?
The DB is ~1GB.
> Regards,
> Ann