From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | AW: relation ### modified while in use |
Date: | 2000-10-23 08:46:14 |
Message-ID: | 11C1E6749A55D411A9670001FA6879633680C0@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> What I'm proposing is that once an xact has touched a
> table, other xacts should not be able to apply schema updates to that
> table until the first xact commits.
No, this would mean too many locks, and would leave the dba with hardly a
chance to alter a table.
If I recall correctly the ANSI standard mandates that schema modifications
be seen immediately. Thus imho we need to refresh the relcache on first
access after modification. Thus two accesses to one table inside one tx
would be allowed to see two different versions (the exception beeing
serializable isolation level).
Imho we only need to lock out an alter table if a cursor is open on that table.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB | 2000-10-23 09:03:41 | AW: embedded sql with indicators in other DBs |
Previous Message | Zeugswetter Andreas SB | 2000-10-23 08:12:47 | AW: to_char() dumps core |