org.postgresql.util.PSQLException

ERROR: operator does not exist: numeric = character varying

Samebug tips1

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>

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web3050

  • ERROR: operator does not exist: numeric = character varying
  • ERROR: operator does not exist: numeric = character varying
  • via openbravo by theroo
    , 1 year ago
    ERROR: operator does not exist: numeric = character varying
  • Stack trace

    • 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) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250) at org.openbravo.data.Sqlc.query(Unknown Source) at org.openbravo.data.Sqlc.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.main(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 1 month ago
    Unknown user
    2 times, 5 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    2 times, 10 months ago
    94 more bugmates