On Fri, 12 Nov 1999, Vadim Mikheev wrote:
> > LOCK <<tablename>> 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?
************************************