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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] A question on GIN indexes and arrays
Дата
Msg-id CAMkU=1xnzFYqYpyK8AR=m97WYQ7zTt+KoFEY81hsMY76be4FOA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] A question on GIN indexes and arrays  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: [GENERAL] A question on GIN indexes and arrays
Список pgsql-general
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 по дате отправления:

Предыдущее
От: marcelo
Дата:
Сообщение: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: [GENERAL] Selecting some schema not suported for libpq PQconnectdbParams