| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | postgresql(at)zr40(dot)nl, Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable |
| Date: | 2021-10-11 18:03:13 |
| Message-ID: | 9b91d241-4d05-e5a4-67da-5b8acdb9a2f1@postgresfriends.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
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).
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2021-10-11 18:12:07 | Re: BUG #17212: pg_amcheck fails on checking temporary relations |
| Previous Message | Mark Dilger | 2021-10-11 17:46:16 | Re: BUG #17212: pg_amcheck fails on checking temporary relations |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2021-10-11 18:12:07 | Re: BUG #17212: pg_amcheck fails on checking temporary relations |
| Previous Message | Mark Dilger | 2021-10-11 17:46:16 | Re: BUG #17212: pg_amcheck fails on checking temporary relations |