How to handle table with token?
How to implement this?
Regards,
Yogesh
On Wednesday, March 8, 2017, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Wednesday, March 8, 2017, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
> On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma <yogeshraj95@xxxxxxxxx> 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.
