At 04:43 AM 2/20/2004, Alan McDonald wrote:

>I've wondered about this - if I have a table with a generated PK and
>numerous other fields.
>I can have literally hundreds of users, and insert operations going on
>simultaneously and I will never get an error - on a pure INSERT statement

But you could - constraints on other fields, foreign key constraints, etc. etc.

>Let's imagine for a simpler case, a table with one field PKID - which gets
>it's value from the generator. It's all serialised past the generator so
>there can't be any errors. Correct?

Not if you include acts of God and the electric company.



Cheers,

Ann
www.ibphoenix.com
We have answers.