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

LLL: serialized and schema objects...

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: hackers(at)postgresql(dot)org
Subject: LLL: serialized and schema objects...
Date: 1998-07-23 03:49:26
Message-ID: 35B6B2C6.63E95C63@krs.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
I need in help:

let's say you have serialized transaction in one session...
Now, some other user drops a table that was in data base when 
serialized transaction began but does it before this transaction
read table (first time)...

1. Will RDBMS allow to drop table? (And so abort
   serialized transaction if it tries read dropped 
   table)
2. Or DROP TABLE will be blocked waiting when
   serialized transaction commits/aborts ?

Could someone test this in Oracle/Informix/Sybase ?

Vadim

Responses

pgsql-hackers by date

Next:From: t-ishiiDate: 1998-07-23 05:05:46
Subject: I18N support in InterBase
Previous:From: Kevin CousinsDate: 1998-07-23 02:55:49
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

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