Yogesh Sharma wrote:
> I observed there is some problem in REINDEX operation in older PostgreSQL
> versions.
> That why i want to add explicitly lock.
Which problem?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Mar 8, 2017 at 3:42 AM, Yogesh Sharma 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
On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma
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.
>
>
You want to exclusively lock a table
Dear Albe,
Thanks for your support.
I observed there is some problem in REINDEX operation in older PostgreSQL
versions.
That why i want to add explicitly lock.
Regards,
Yogesh
On Wednesday, March 8, 2017, Albe Laurenz wrote:
> Yogesh Sharma wrote:
> > I want to apply explicitly lock mechanis
Yogesh Sharma wrote:
> 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.
Maybe I misunderstand something, but you don't need to do that because it
happens automatic
Dear Scott,
How to handle table with token?
How to implement this?
Regards,
Yogesh
On Wednesday, March 8, 2017, Scott Marlowe wrote:
> On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe > wrote:
> > On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma > wrote:
> >> Dear David,
> >>
> >> I want to app
On Tue, Mar 7, 2017 at 11:55 PM, Scott Marlowe wrote:
> On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma 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 ha
On Tue, Mar 7, 2017 at 11:21 PM, Yogesh Sharma 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
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
On Wednesday, March 8, 2017, David G. Johnston
wrote:
> On Tuesday, March 7, 2017, Yogesh S
On Tuesday, March 7, 2017, Yogesh Sharma wrote:
> Dear all,
>
> Thanks for your support.
>
> I need to perfrom INSERT and REINDEX operation exclusively.
> For example:
> If REINDEX operation is in progress then INSERT operation will wait and
> vice versa.
>
> Please let me know if any approach i
Dear all,
Thanks for your support.
I need to perfrom INSERT and REINDEX operation exclusively.
For example:
If REINDEX operation is in progress then INSERT operation will wait and
vice versa.
Please let me know if any approach is available.
Regards,
Yogesh sharma
11 matches
Mail list logo
