Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Request to confirm which command is use for exclusive operation - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] Request to confirm which command is use for exclusive operation
Date
Msg-id CAOR=d=1eoibsOCOcn738jO--c2thtcoF87EhEC_BYJP=XhVwJA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
List pgsql-general
Tree view 
On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma <yogeshraj95@gmail.com> 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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation
Next
From: vinny
Date:
Subject: Re: [GENERAL] Postgres, apps, special characters and UTF-8 encoding