From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | PostgreSQL Developers List <hackers(at)postgreSQL(dot)org> |
Subject: | Q: RI and isolevels |
Date: | 1999-06-16 03:55:33 |
Message-ID: | 37672035.C0E84FEF@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Standard (draft) says:
Regardless of the isolation level of the SQL-transaction, phenomena
P1, P2, and P3 shall not occur during the implied reading of schema
definitions performed on behalf of executing an SQL-statement, the
checking of integrity constraints, and the execution of referen-
tial actions associated with referential constraints.
I'm not sure what they exactly mean. Could someone run two tests
for me (in Oracle and Informix/Sybase)?
create table p (k integer primary key);
create table f (k integer references p(k));
session-1:
set transaction isolation mode serializable;
select * from f; -- just to ensure that xaction began -:)
session-2:
insert into p values (1);
commit;
session-1:
insert into f values (1);
--
-- Results? Abort?
--
What's the result in the case of read committed isolevel in
session-1? Is insert succeeded?
TIA!
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-06-16 04:16:12 | Postgres mailing lists |
Previous Message | Cyril VELTER | 1999-06-15 23:43:31 | BeOS port |