Re: ERROR: operator class "gin__int_ops" does not exist for access method "gin"

2019-04-18 Thread Adrian Klaver
On 4/17/19 9:38 PM, Julie Nishimura wrote: Thank you! All works now Great. I mentioned upstream about migrating to version newer then 9.4. Given the amount of work you are putting into this, would you not be better served by going to a version that has more then ~10 months left on its commun

Re: ERROR: operator class "gin__int_ops" does not exist for access method "gin"

2019-04-17 Thread Julie Nishimura
Thank you! All works now From: Adrian Klaver Sent: Wednesday, April 17, 2019 5:23 PM To: Julie Nishimura; pgsql-general@lists.postgresql.org Subject: Re: ERROR: operator class "gin__int_ops" does not exist for access method "gin" On 4/

Re: ERROR: operator class "gin__int_ops" does not exist for access method "gin"

2019-04-17 Thread Adrian Klaver
On 4/17/19 5:18 PM, Julie Nishimura wrote: 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