org.postgresql.util.PSQLException: ERROR: operator does not exist: numeric = character varying

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 openbravo by carlossl
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched
via openbravo by irasyid
, 1 year ago
ERROR: could not read block 0 of relation 1663/38140/2659: Invalid argument
via GitHub by dotjorgeu
, 2 years ago
ERROR: insert or update on table "publishing_bundle_environment" violates foreign key constraint "fk_bundle_id" Detail: Key (bundle_id)=(dbc71cca-29ab-47b4-b33a-50de3549da1f) is not present in table "publishing_bundle".
via openbravo by victorbayon
, 1 year ago
ERROR: function to\_char(character varying) does not exist
org.postgresql.util.PSQLException: ERROR: operator does not exist: numeric = character varying
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)

Users with the same issue

4 times, 6 months ago
17 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago
100 more bugmates

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