Re: locking a table

From: Simone Tellini <tellini(at)areabusiness(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: locking a table
Date: 2002-12-23 17:35:56
Message-ID: 20021223183309.22AB.TELLINI@areabusiness.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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;"

--

Simone Tellini
E-mail: tellini(at)areabusiness(dot)it
http://www.areabusiness.it

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Schmitz 2002-12-23 17:37:24 Re: locking a table
Previous Message Andreas Schmitz 2002-12-23 17:02:24 locking a table