overlapping insert transactions

[humanista (mruczus)]

Can two or more overlapping insert transactions to the same interbase 6
table at all fail? Why?

By the way, I wonder if there can be other reason of insert rollback than
unique value violation.

[Bill Todd [TeamB]]

Post by humanista (mruczus)
Can two or more overlapping insert transactions to the same interbase
6 table at all fail? Why?

Certainly.
1) Primary key conflict.
2) Failing a unique constraint.
3) Failing a check constraint.
4) Failing a custom constraint implemented in a trigger.

Post by humanista (mruczus)
By the way, I wonder if there can be other reason of insert rollback
than unique value violation.

See the list above.