Re: [HACKERS] Q: RI and isolevels

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
Cc: PostgreSQL Developers List <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Q: RI and isolevels
Date: 1999-06-16 08:38:42
Message-ID: 37676292.3B297C5F@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-06-16 10:11:42 Re: [HACKERS] Postgres mailing lists
Previous Message ZEUGSWETTER Andreas IZ5 1999-06-16 08:09:44 Re: [HACKERS] Q: RI and isolevels