Fwd: Want to acquire lock on tables where primary of one table isforeign key on othere

Поиск
Список
Период
Сортировка
От Abhishek Tripathi
Тема Fwd: Want to acquire lock on tables where primary of one table isforeign key on othere
Дата
Msg-id CACun91NMA2fcmnxY8LYEYQuuYywvzQAW4oxKQffq5PDPS87Oxw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Want to acquire lock on tables where primary of one table isforeign key on othere  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general


---------- Forwarded message ---------
From: Abhishek Tripathi <postforabhishek@gmail.com>
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: <pgsql-bugs@lists.postgresql.org>


Dear Concerned Person,
 I write this email to get the information about locking which I am not getting from anywhere.
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.



Thanks and Regards 
Abhishek

В списке pgsql-general по дате отправления:

Предыдущее
От: magodo
Дата:
Сообщение: Re: how to identify the timeline of specified recovery_target_timewhen do multiple PITR
Следующее
От: magodo
Дата:
Сообщение: parallel PITR for HA setup