Want to acquire lock on tables where primary of one table is foreignkey on othere

Поиск
Список
Период
Сортировка
От Abhishek Tripathi
Тема Want to acquire lock on tables where primary of one table is foreignkey on othere
Дата
Msg-id CACun91P3X0R2g+E49_Kd7GKSNq0mJOhbpvLHv2XX-dUxyQFJaw@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
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-bugs по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: BUG #15383: Join Filter cost estimation problem in 10.5
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #15425: DETACH/ATTACH PARTITION bug