I have the following table:
create table test(
key int8,
length int4,
level int4,
pu oid,
primary key(key));
Now I have two concurrent transactions:
At the time the transactions start, there does't exist a row with value 1 for
the key column.
time transactionA:
1 begin;
2 set transaction level serializable;
3 insert into test(1,..,..,..);
4
5 commit;
time transactionB:
1 begin;
2 set transaction level serializable;
3
4 insert into test(1,..,..,..);
5
6 commit;
So my question is, what happens with the insert of transactionB?
Since a row with primary key value 1 doesn't exist within transactionB when
executing the insert-statement, it shouldn't be a problem within the
transaction.
But if so, how will the constraint be fullfilled? Will transactionB be aborted?
Is there a difference running in transaction level serializable or readcommited?
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
