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=30aMi=Uo5OKRinSJSAVBybf3yeKbSDZP=ZsBaK9bbC-w@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
Responses Re: [GENERAL] Request to confirm which command is use for exclusive operation  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Yogesh Sharma
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Request to confirm which command is use for exclusive operation