Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Q about read committed in Oracle...

From: "Dr(dot) Michael Meskes" <meskes(at)online-club(dot)de>
To: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Q about read committed in Oracle...
Date: 1998-07-27 14:45:33
Message-ID: 19980727164533.A2413@feivel.online-club.de (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Jul 14, 1998 at 07:14:10PM +0800, Vadim Mikheev wrote:
> Could someone run in Oracle test below?

I could, but how do I make Oracle use read committed mode?

> 
> 1.  CREATE TABLE test (x integer, y integer)
> 2.  INSERT INTO test VALUES (1, 1);
>     INSERT INTO test VALUES (1, 2);
>     INSERT INTO test VALUES (3, 2);
> 3.  run two session T1 and T2 (in read committed mode)
> 4.  in session T2 run
>     UPDATE test SET x = 1, y = 2 WHERE x <> 1 OR y <> 2;
> 5.  in session T1 run
>     UPDATE test SET y = 3 WHERE x = 1;
> 6.  in session T2 run
>     COMMIT;
> 7.  in session T1 run
>     SELECT * FROM test;         -- results?
> 8.  in session T1 run
>     COMMIT;
> 9.  now in session T2 run
>     UPDATE test SET x = 2;
> 10. in session T1 run
>     UPDATE test SET y = 4 WHERE x = 1;
> 11. in session T2 run
>     COMMIT;
> 12. in session T1 run
>     SELECT * FROM test;         -- results?
> 
> TIA,
>         Vadim

Michael
-- 
Dr. Michael Meskes		meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire!	Use Debian GNU/Linux! 

In response to

Responses

pgsql-hackers by date

Next:From: Dr. Michael MeskesDate: 1998-07-27 14:54:07
Subject: Re: [HACKERS] proposals for LLL, part 1
Previous:From: Dr. Michael MeskesDate: 1998-07-27 14:37:40
Subject: Re: [HACKERS] Hey Linux People (OT)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group