Search Postgresql Archives

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

Subject: Re: Request to confirm which command is use for exclusive operation
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 8 Mar 2017 09:01:57 -0700
Cc: Albe Laurenz <laurenz.albe@xxxxxxxxxx>, pgsql-general general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAEZUwCSK1JPEFwzmqQ--cG38VguQeTjpe=0SuPy4M-L=4SFhqg@mail.gmail.com>
References: <CAEZUwCQs6j795TVbiB5Uu1rqkMkLL-hrbPPGitZ6bj7c9DwBCg@mail.gmail.com> <CAKFQuwbXW+EZkR-kFXre6x=SY92PBj+5_scM125vpfzQAupQxA@mail.gmail.com> <CAEZUwCS-F00Amyf7uScw7e35A2cop=J4fTyU9spXjQ3aHxyMjw@mail.gmail.com> <A737B7A37273E048B164557ADEF4A58B53A0691D@ntex2010i.host.magwien.gv.at> <CAEZUwCSK1JPEFwzmqQ--cG38VguQeTjpe=0SuPy4M-L=4SFhqg@mail.gmail.com>

On Wed, Mar 8, 2017 at 3:42 AM, Yogesh Sharma <yogeshraj95@xxxxxxxxx> wrote:

I observed there is some problem in REINDEX operation in older PostgreSQL versions.
That why i want to add explicitly lock.

You should probably define "current" and "older" in your personal context - what version(s) are you targeting?

David J.

References:
- Request to confirm which command is use for exclusive operation
  - From: Yogesh Sharma
- Re: Request to confirm which command is use for exclusive operation
  - From: David G. Johnston
- Re: Request to confirm which command is use for exclusive operation
  - From: Yogesh Sharma
- Re: Request to confirm which command is use for exclusive operation
  - From: Albe Laurenz
- Re: Request to confirm which command is use for exclusive operation
  - From: Yogesh Sharma