Re: REINDEX CONCURRENTLY unexpectedly fails - Mailing list pgsql-bugs

From Tom Lane
Subject Re: REINDEX CONCURRENTLY unexpectedly fails
Date
Msg-id 19198.1573663534@sss.pgh.pa.us
Whole thread Raw
In response to Re: REINDEX CONCURRENTLY unexpectedly fails  (Andres Freund <andres@anarazel.de>)
Responses Re: REINDEX CONCURRENTLY unexpectedly fails
List pgsql-bugs
Andres Freund <andres@anarazel.de> writes:
> On 2019-11-13 10:59:08 -0500, Tom Lane wrote:
>> It's not real clear why there would be any point in (RE)INDEX
>> CONCURRENTLY on a temp table anyway, since no other session could
>> be using it.

> I guess it's not necessarily always clear in all contexts that one is
> dealing with a temp table, rather than a normal table.

That's a good point.

> I wonder if we instead ought to just ignore the CONCURRENTLY when
> targetting a temp table? That'd be a correct optimization for temp
> tables, and would fix the issue at hand...

Oh, I like that idea.  Keeps applications from having to think
about this.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Cagri Biroglu
Date:
Subject: repomd.xml update
Next
From: Tom Lane
Date:
Subject: Re: Unexpected "cache lookup failed for collation 0" failure