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: (view raw, whole thread or download thread mbox)
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 
2. Or DROP TABLE will be blocked waiting when
   serialized transaction commits/aborts ?

Could someone test this in Oracle/Informix/Sybase ?



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-2017 The PostgreSQL Global Development Group