Re: Force Lock - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Force Lock
Date
Msg-id 20030829023344.GA4373@wolff.to
Whole thread Raw
In response to Force Lock  ("Girish Bajaj" <gbajaj@tietronix.com>)
List pgsql-novice
On Thu, Aug 28, 2003 at 15:17:34 -0500,
  Girish Bajaj <gbajaj@tietronix.com> wrote:
> Hello all,
>
>
>
> Is there a way I can force a more aggressive lock on a table in a SELECT
> statement that's being executed in a transaction?
>
>
>
> SELECT FOR UPDATE is not aggressive enough. I need an exclusive lock on that
> particular table the select is accessing.

You can use a LOCK statement to do this.

pgsql-novice by date:

Previous
From: "Luis H."
Date:
Subject: select items, and max id
Next
From: Bruno Wolff III
Date:
Subject: Re: select items, and max id