search

graphile / crystal

🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!
https://graphile.org/
Other
12.63k stars 572 forks source link

error: operator is not unique: smallint[] @> smallint[] #12

Closed rattrayalex closed 8 years ago

rattrayalex commented 8 years ago

I got this error when running postgraphql on a DB I have:

error: operator is not unique: smallint[] @> smallint[]

Tracked it down to https://github.com/calebmer/postgraphql/blob/master/src/postgres/getCatalog.js#L70 

cp.conkey @> array[a.attnum]

I'm working to debug/fix, but wanted to post here in the meantime.

rattrayalex commented 8 years ago

Casting a.attnum to int appears to work: 

cp.conkey @> array[a.attnum::int]

PR forthcoming

calebmer commented 8 years ago

Fixed 😊 👍

I'll publish soon.

calebmer commented 8 years ago

Fix published in version 1.2.1

hartraft commented 5 years ago

I still have this error:

$ postgraphile --version
4.2.0

A fatal error occurred when building the initial schema, so the process will now exit. Error details:

error: operator is not unique: smallint[] @> smallint[]

benjie commented 5 years ago

Use postgraphile@4.3.0