ERROR: operator class "gin__int_ops" does not exist for accessmethod "gin"

Поиск
Список
Период
Сортировка
От Julie Nishimura
Тема ERROR: operator class "gin__int_ops" does not exist for accessmethod "gin"
Дата
Msg-id BYAPR08MB50147B68654B4023712FC6B1AC260@BYAPR08MB5014.namprd08.prod.outlook.com
обсуждение исходный текст
Ответы Re: ERROR: operator class "gin__int_ops" does not exist for accessmethod "gin"
Список pgsql-general
Дерево обсуждения
We migrated some tables from 8.3 postgresql to 9.4, and when I compared tables DDL between environments, I've noticed some indices are missing (majority of them are using GIN

When I am taking 8.3 ddl for it:
  CREATE INDEX serp_test2
  ON serp_test
  USING gin
  (domainids gin__int_ops);

it gives me error:
ERROR:  operator class "gin__int_ops" does not exist for access method "gin"

Is it possible to retrieve the ddl for operator class and recreate it on 9.4? If not, is there any work-around?

Thank you

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: is it possible to create partitioned tables using tables fromdifferent schemas
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: ERROR: operator class "gin__int_ops" does not exist for accessmethod "gin"