"Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> writes:
> There isn't possibility change opclass for generated UNIQUE indexes.
Why would you need it?
> USING INDEX [TABLESPACE ..] [OPCLASS ..]
This is unworkable --- consider a table with more than one unique
constraint and/or multiple-column constraints.
I seem to recall someone proposing extending the syntax of the UNIQUE
constraints themselves, but there really isn't enough use-case to
justify it AFAICS. Especially not when you can always use CREATE UNIQUE
INDEX.
regards, tom lane