From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] MVCC works in serialized mode! |
Date: | 1998-12-25 10:32:44 |
Message-ID: | 368369CC.9B76D53A@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> 2. LOCK TABLE modes are not yet implemented...
Implemented, as well as SET TRANSACTION ISOLATION LEVEL...
>
> 3. As well as SELECT ... FOR UPDATE: I need in advice here!
>
> Do Oracle, Informix etc support SELECT FOR UPDATE if
> there are aggregates, group by, distinct in SELECT ???
As I see in Oracle documentation FOR UPDATE is disallowed
in these cases... No objections ?
> Is SELECT FOR UPDATE allowed in subqueries ???
Could someone test this?
>
> 7. As I read in Sybase documentation the default
> standard transaction mode is _chained_ - all
> queries before explicit COMMIT/ABORT are run in _single
> transaction_... But we have to use BEGIN/END to get it!
> This was not so bad for system with relation level locks,
> but now only the same row writes block one other and so
> chained mode seems more appropriate...
>
> Shouldn't we change default transaction mode now?
> And use option/SET TRANSACTION MODE to switch to
> un-chained mode if one like it?
No comments on this?
I would like to make BEGIN implicit...
Objections?
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-12-25 11:22:01 | Re: [HACKERS] postgresql-6.4.1.tar.gz |
Previous Message | Edmund Mergl | 1998-12-25 08:35:13 | postgresql-6.4.1.tar.gz |