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: | Raw Message | Whole Thread | 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
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. |