org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying ヒント: No operator matches the given name and argument type(s). You might need to add explicit type casts. ポジション: 37

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via co.jp by Unknown author, 9 months ago
ERROR: operator does not exist: integer = character varying ヒント: No operator matches the given name and argument type(s). You might need to add explicit type casts. ポジション: 37
via Google Groups by Mike Starov, 2 years ago
ERROR: function function1(bigint) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
via Google Groups by YourSoft, 3 months ago
ERROR: function with OID 63315074 does not exist
via GitHub by gfodor
, 1 year ago
ERROR: cached plan must not change result type
via nabble.com by Unknown author, 1 year ago
ERROR: could not determine data type of parameter $1
via Google Groups by Thomas Kellerer, 4 months ago
ERROR: argument to pg_get_expr() must come from system catalogs
org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying ヒント: No operator matches the given name and argument type(s). You might need to add explicit type casts. ポジション: 37
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at undefined.Test.main(Test.java:10)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 3 days ago
104 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.