Force Lock

From: "Girish Bajaj" <gbajaj(at)tietronix(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Force Lock
Date: 2003-08-28 20:17:34
Message-ID: 003d01c36da1$6a9f4190$7764a8c0@tietronix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

I cant seem to figure out how to get this working.

Thanks,

Girish

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luis H. 2003-08-29 02:11:49 select items, and max id
Previous Message WillyLinux - 2003-08-28 14:21:30 Unsubscribe