postgres_dba icon indicating copy to clipboard operation
postgres_dba copied to clipboard

"operator is not unique" on i3 check

Open dewey opened this issue 1 year ago • 1 comments

Hey, I just gave this a try but I'm running into this on the i3 check. Using it on macOS and connecting to Google CloudSQL PG 16.

Type your choice and press <Enter>:
i3
psql:/Users/user/repos/github.com/NikolayS/postgres_dba/sql/i3_non_indexed_fks.sql:124: ERROR:  operator is not unique: smallint[] pg_catalog.@> smallint[]
LINE 58: ...(indkey::int2[])[0:(array_length(key_cols,1) -1)] operator(p...
                                                              ^
HINT:  Could not choose a best candidate operator. You might need to add explicit type casts.
Press <Enter> to continue…

It seems like this got changed a while ago, so I'm not sure what's going on there: https://github.com/NikolayS/postgres_dba/pull/35/files

dewey avatar Oct 08 '24 16:10 dewey