Re: [HACKERS] Q: RI and isolevels - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Q: RI and isolevels
Date
Msg-id 37676292.3B297C5F@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Q: RI and isolevels  (ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>)
List pgsql-hackers
ZEUGSWETTER Andreas IZ5 wrote:
> 
> In Informix:
> > set transaction isolation level serializable;
>    Informix needs:          ^^^^^   level not mode

This was my fault...

> > session-1:
> > insert into f values (1);
> > --
> > -- Results? Abort?
> > --
> >
> Goes ok in both isolation levels. Only if session-2 insert is not committed,

Well... Thanks!
The problem for us and Oracle: subsequent selects from p in
session-1 will not return key 1... So, I would like to know
what Oracle does...

Vadim


pgsql-hackers by date:

Previous
From: ZEUGSWETTER Andreas IZ5
Date:
Subject: Re: [HACKERS] Q: RI and isolevels
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Postgres mailing lists