Re: locking a table - Mailing list pgsql-admin

From Simone Tellini
Subject Re: locking a table
Date
Msg-id 20021223183309.22AB.TELLINI@areabusiness.it
Whole thread Raw
In response to locking a table  (Andreas Schmitz <a.schmitz@cityweb.de>)
Responses Re: locking a table  (Andreas Schmitz <a.schmitz@cityweb.de>)
Re: locking a table  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
On Mon, 23 Dec 2002 18:02:24 +0100
Andreas Schmitz <a.schmitz@cityweb.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;"

--

Simone Tellini
E-mail: tellini@areabusiness.it
http://www.areabusiness.it


pgsql-admin by date:

Previous
From: "Rob Abernethy IV"
Date:
Subject: SSL Mode
Next
From: Andreas Schmitz
Date:
Subject: Re: locking a table