Re: Force Lock

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Girish Bajaj <gbajaj(at)tietronix(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Force Lock
Date: 2003-08-29 02:33:44
Message-ID: 20030829023344.GA4373@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Aug 28, 2003 at 15:17:34 -0500,
Girish Bajaj <gbajaj(at)tietronix(dot)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.

In response to

  • Force Lock at 2003-08-28 20:17:34 from Girish Bajaj

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-29 02:36:25 Re: select items, and max id
Previous Message Browne, George (AT-Atlanta) 2003-08-29 02:27:16 How does it work