Re: [GENERAL] A question on GIN indexes and arrays

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: [GENERAL] A question on GIN indexes and arrays
Дата
Msg-id CAOC+FBWU51QMFoUoPEoT7GHmiymm8VF_-Bbfj0SpAQUuLu9-Ag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] A question on GIN indexes and arrays  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [GENERAL] A question on GIN indexes and arrays
Список pgsql-general
Дерево обсуждения
YES!

\dx yields intarray was installed (back in the 9.1 days, maybe) and that was clobbering the @> operator.

Looking into the implications of removing intarray now that we're at 9.6, seems harmless, but will do my due diligence.

Thanks Jeff.



On Sun, Aug 20, 2017 at 3:15 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
On Sun, Aug 20, 2017 at 1:28 PM, Wells Oliver <wells.oliver@gmail.com> wrote:

Why is this happening and what can I do to get my GIN indexes working? Thanks!


What extensions do you have installed in each database?  I bet one of them (like intarray) redefines @> for one of your databases. 

Try fully qualifying the operator.  OPERATOR(pg_catalog.@>)

Cheers,

Jeff



--

В списке pgsql-general по дате отправления:

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams
Следующее
От: Wells Oliver
Дата:
Сообщение: Re: [GENERAL] A question on GIN indexes and arrays