[ please keep the list cc'd ]
Steven Lembark <lembark@wrkhors.com> writes:
> On Thu, 10 May 2018 11:52:48 -0400
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Maybe you should show a more concrete example of what's not working.
> The problem is with gists telling me that they cannot index
> the type. This works for enums, just not the composite type.
Oh, well, they can't. There's no GiST opclass covering arbitrary
composite types. This doesn't seem very surprising to me given
the lack of operators that such an opclass might accelerate.
What are you expecting an index on such a column to do for you?
If you just want a uniqueness constraint, plain btree can handle it.
regards, tom lane