Re: Request to confirm which command is use for exclusive operation

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Request to confirm which command is use for exclusive operation
Date: 2017-03-08 06:55:51
Message-ID: CAOR=d=30aMi=Uo5OKRinSJSAVBybf3yeKbSDZP=ZsBaK9bbC-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma <yogeshraj95(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2017-03-08 06:57:28 Re: Request to confirm which command is use for exclusive operation
Previous Message Yogesh Sharma 2017-03-08 06:21:29 Re: Request to confirm which command is use for exclusive operation