Re: locking a table

On Monday 23 December 2002 18:35, Simone Tellini wrote:
> On Mon, 23 Dec 2002 18:02:24 +0100
> Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> wrote:
>
> AS> LOCK [ TABLE ] name [, ...] IN lockmode MODE
> [...]
> AS> newsdb=# lock table dpa in lockmode 'exclusive';
> AS> ERROR: parser: parse error at or near "lockmode" at character 19
>
> you might want to try "lock dpa in exclusive mode;"

Hi,

newsdb3=# lock dpa in exclusive mode;

that one worked without errors. connecting as a normal user

psql -U dbimport newsdb3

and doing a

newsdb3=> select id from dpa limit 5;
id
--------
73424
73430
69445
73431
109217
(5 rows)

Maybe I have a different idea of exclusive.

kind regards

-andreas

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de