-- Forwarded message -
From: Abhishek Tripathi
Date: Thu, Oct 11, 2018 at 3:18 PM
Subject: Want to acquire lock on tables where primary of one table is
foreign key on othere
To:
Dear Concerned Person,
I write this email to get the information about locking which I am not
On Thu, 11 Oct 2018 at 16:38, Abhishek Tripathi
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
> AccessSh
You forgot to CC the list. Also, top-posting is generally not appreciated here.
> On Thu, Oct 11, 2018 at 8:26 PM Alban Hertroys wrote:
> On Thu, 11 Oct 2018 at 16:38, Abhishek Tripathi
> wrote:
> > Actually I have acquired a "Select for Update" on a table whose id is
> > refrence as a foreign
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 ke