Rob Sargent <rsargent@xxxxxxxxxxxx> writes: > I’ve hit this same message > Caused by: org.postgresql.util.PSQLException: ERROR: right sibling of GIN page is of different type > in a couple of contexts and I’m starting to get worried. If you can make a test case that (eventually) hits that, we'd be interested to see it ... > and I um, er, enabled gin on uuid by copying from a thread in this list, as follows: > create operator class _uuid_ops > default for type _uuid > using gin as > operator 1 &&(anyarray, anyarray) > ,operator 2 @>(anyarray, anyarray) > ,operator 3 <@(anyarray, anyarray) > ,operator 4 =(anyarray, anyarray) > ,function 1 uuid_cmp(uuid, uuid) > ,function 2 ginarrayextract(anyarray, internal, internal) > ,function 3 ginqueryarrayextract(anyarray, internal, smallint, internal, internal, internal, internal) > ,function 4 ginarrayconsistent(internal, smallint, anyarray, integer, internal, internal, internal, internal) > ,storage uuid; You should not have needed to do that, I think, as the standard anyarray GIN opclass should've handled it. Having said that, I don't immediately see anything broken about this definition, so it seems like it should've worked. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
