Re: BUG #18637: CREATE INDEX won't look up operator classes in search_path if PARTITION BY is specified

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, usamoi(at)outlook(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18637: CREATE INDEX won't look up operator classes in search_path if PARTITION BY is specified
Date: 2024-10-05 18:48:05
Message-ID: 1055980.1728154085@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Noah Misch <noah(at)leadboat(dot)com> writes:
> On Thu, Oct 03, 2024 at 02:17:15PM -0400, Tom Lane wrote:
>> This could stand an additional regression test case perhaps,
>> but the core tests don't have a suitable opclass at hand.
>> Maybe we could test it in some contrib module, but that
>> seems a shade hacky.

> For contrib/citext/sql/create_index_acl.sql, I settled on testing in contrib.
> I valued the test fidelity of a real opclass more than I disliked the use of
> contrib. The distinction between the various parts of check-world is blurry
> to non-hackers, so I expect it won't bother them.

Agreed. Pushed it with a test added to contrib/seg, just to be
different.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Cameron Vogt 2024-10-05 22:11:54 Re: PostgreSQL 17 Segmentation Fault
Previous Message Murat Efendioğlu 2024-10-05 17:46:02 Error when setting default_text_search_config