locking a table

From: Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: locking a table
Date: 2002-12-23 17:02:24
Message-ID: 200212231802.24128.a.schmitz@cityweb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello *,

I just tried to lock a table in exclusive mode following the syntax provided
by \h lock

LOCK [ TABLE ] name [, ...] IN lockmode MODE

and I get the following result:

newsdb=# lock table dpa in lockmode 'exclusive';
ERROR: parser: parse error at or near "lockmode" at character 19
newsdb=# lock table dpa in lockmode exclusive;
ERROR: parser: parse error at or near "lockmode" at character 19
newsdb=#

Did I get it totally wrong and I am badly in need of some holidays or is there
something wrong with the syntax ?

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Simone Tellini 2002-12-23 17:35:56 Re: locking a table
Previous Message Robert M. Meyer 2002-12-23 16:34:34 Postgres 7.2.3 hangs during vacuum.