Thank you for your response. I am explaining my situation there is table A on which I have taken a row lock and the primary key of table A is related with table B as a foreign key so automatically I can not insert new row with that foreign key now the primary key of table B is used as foreign key in table C and insertion can be done on table C. I just want to lock table C also No insertion can be done on table C related to table B primary key.
On Thu, Oct 11, 2018 at 8:26 PM Alban Hertroys <[email protected]> wrote: > On Thu, 11 Oct 2018 at 16:38, Abhishek Tripathi > <[email protected]> wrote: > > Actually I have acquired a "Select for Update" on a table whose id is > refrence as a foreign key on another table So I want those table won't > update until there is lock. Is it possible? Becuase postgres is acquiring > lock but AccessShare Lock which allow to write on those table How I > restrict this. > > For what purpose do you want that? What is inadequate about the lock > that Postgres acquires? > > Table locks are very rarely what you want, as it blocks all concurrent > access to the entire table, while that is only necessary for a few > rarely used corner cases; a foreign key update is not among those. > > -- > If you can't see the forest for the trees, > Cut the trees and you'll see there is no forest. >
