Re: [GENERAL] Postgres concurrency : urgent
От
Marcin Inkielman
Тема
Re: [GENERAL] Postgres concurrency : urgent
Дата
Msg-id
Pine.LNX.4.04.9911120923570.26188-100000@mi.marnnet
Ответ на
Re: [GENERAL] Postgres concurrency : urgent (Vadim Mikheev)
Список
Дерево обсуждения
Re: [GENERAL] Postgres concurrency : urgent Chairudin Sentosa Harjo <chai@prima.net.id>
Re: [GENERAL] Postgres concurrency : urgent Marcin Inkielman <marn@wsisiz.edu.pl>
On Fri, 12 Nov 1999, Vadim Mikheev wrote:
> > LOCK <> IN ACCESS EXCLUSIVE MODE;
> ^^^^^^
> This blocks concurrent read access - is it what you really want?
>
I know it is rather restrictive but when applied to a sequence it inhibits
to a unterminated transaction to change sequence current value (with
for example SELECT nextval('seq')) - ROLLBACK doesn't revert
previous sequence curr. value.
(sorry for my English)
************************************
Marcin Inkielman
************************************
.~.
/V\
// \\
/( )\
^`~'^
powered by Linux
----
sibi omino similis?
************************************
В списке pgsql-general по дате отправления
