Re: Corruption with IMMUTABLE functions in index expression. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Corruption with IMMUTABLE functions in index expression.
Date
Msg-id 477319.1633978762@sss.pgh.pa.us
Whole thread Raw
In response to Re: Corruption with IMMUTABLE functions in index expression.  (Andres Freund <andres@anarazel.de>)
Responses Re: Corruption with IMMUTABLE functions in index expression.  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Perhaps we could set pg_index.indisvalid to false initially, and if opening an
> index where pg_index.indisvalid error out with a different error message if
> TransactionIdIsCurrentTransactionId(xmin). And then use an inplace update to
> set indisvalid to true, to avoid the bloat?

I still can't get excited about it ... but yeah, update-in-place would
be enough to remove the bloat objection.  I doubt we need any code
changes beyond changing the indisvalid state.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: BUG #17212: pg_amcheck fails on checking temporary relations
Next
From: Bharath Rupireddy
Date:
Subject: Accommodate startup process in a separate ProcState array slot instead of in MaxBackends slots.