operator does not exist: text = bytea

From: Karthik K L V <venkata(dot)karthik4u(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: operator does not exist: text = bytea
Date: 2022-07-20 09:32:13
Message-ID: CAGpQzhyp+Jfvz1BveXupEzw48gofzwy=xHW143z50ouJHu-4jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

I am getting the below error while executing a Select query using Spring
DataJPA and Hibernate framework in Aurora Postgres SQL.

*Caused by: org.postgresql.util.PSQLException: ERROR: operator does not
exist: text = bytea Hint: No operator matches the given name and argument
types. You might need to add explicit type casts. Position: 1037*

We have a query with bind value which sometimes gets resolved to null (no
data) depending on the application scenario.
The datatype of the bindvalue and the corresponding column is String.
The same query executes fine when the value of the bindvalue is populated.

Could you please let me know how I can resolve this issue without making
changes to the query?
Is there any configuration available in the Postgres Driver or on the
Postgres DB Server which can be set to resolve null bind values?

Appreciate your help. Thank you.

--
Karthik klv

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2022-07-20 09:33:25 Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Previous Message Sebastien Flaesch 2022-07-20 09:15:29 Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence