| From: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
|---|---|
| To: | Vik Fearing <vik(at)postgresfriends(dot)org>, "postgresql(at)zr40(dot)nl" <postgresql(at)zr40(dot)nl>, Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable |
| Date: | 2021-10-13 00:06:32 |
| Message-ID: | E29EF33B-CA1A-4146-BFCF-C8EC08FB91A8@amazon.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 10/11/21, 11:03 AM, "Vik Fearing" <vik(at)postgresfriends(dot)org> wrote:
> On 10/11/21 5:25 PM, PG Bug reporting form wrote:
>>
>> User 'musttu' on IRC reported the following bug: After running "ALTER INDEX
>> some_idx ALTER COLUMN expr SET (n_distinct=100)", the index and table become
>> unusable. All further statements involving the table result in: "ERROR:
>> operator class text_ops has no options".
>>
>> They reported this on the RDS version of 13.3, but I've been able to
>> reproduce this on Debian with 13.4 and 14.0. It does not reproduce on 12.8,
>> all statements succeed on that version.
>
> This was broken by 911e702077 (Implement operator class parameters).
Moving to pgsql-hackers(at)(dot)
At first glance, it looks like ALTER INDEX .. ALTER COLUMN ... SET
uses the wrong validation function. I've attached a patch where I've
attempted to fix that and added some tests.
Nathan
| Attachment | Content-Type | Size |
|---|---|---|
| alter_index_column_set_validation.patch | application/octet-stream | 4.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vik Fearing | 2021-10-13 00:30:09 | Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable |
| Previous Message | Tom Lane | 2021-10-12 20:40:25 | Re: BUG #17225: Query with CTE failed after upgrade Postgres from 11 to 12/13 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2021-10-13 00:16:57 | Re: Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit() |
| Previous Message | Andres Freund | 2021-10-12 23:54:35 | Re: [RFC] building postgres with meson |