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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
