Re: BUG #18500: Detaching a partition with an index manually attached to the parent's index triggers Assert

Tender Wang <tndrwang@gmail.com>

From: Tender Wang <tndrwang@gmail.com>

To: Alvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Michael Paquier <michael@paquier.xyz>, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org

Date: 2024-07-04T07:57:05Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix ALTER TABLE DETACH for inconsistent indexes
- d0054432d480 12.20 landed
- 83917791385a 18.0 landed
- 66aaa7a71841 14.13 landed
- 4ae09c59d6f5 15.8 landed
- 30ca4e1ab1ff 17.0 landed
- 05748256939b 13.16 landed
- 00a40e33c0a4 16.4 landed

Alvaro Herrera <alvherre@alvh.no-ip.org> 于2024年7月4日周四 02:21写道：

> Did anybody figure out a way to repair the problematic situation without
> having to recreate the whole index hierarchy?  If so, please let me
> know.  For full context, see below.
>

...Hmm, it is not trivial work. Strong consistency  means that we
may sacrifice other things.


-- 
Tender Wang