Dear Scott, How to handle table with token? How to implement this?
Regards, Yogesh On Wednesday, March 8, 2017, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe <scott.marl...@gmail.com > <javascript:;>> wrote: > > On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma <yogeshra...@gmail.com > <javascript:;>> wrote: > >> Dear David, > >> > >> I want to apply explicitly lock mechanism once inset operation is in > >> progress then REINDEX will wait. > >> And vice versa. > >> So, please let me know this type of handling is possible. > >> Regrds, > >> Yogesh > > > > Create two roles grant / revoke permissions as needed. maybe > > pg_stat_activity for locks etc > > Also you could have a table with a simple token in it etc. active > process gets token, all other processes wait on it. >
