On Monday 23 December 2002 18:35, Simone Tellini wrote: > On Mon, 23 Dec 2002 18:02:24 +0100 > Andreas Schmitz <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org