agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
From: Karen Goh <karenworld@yahoo.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Date: Tue, 16 Jul 2019 09:25:15 +0000 (UTC)
Message-ID: <1919398337.1106688.1563269115584@mail.yahoo.com> (raw)
In-Reply-To: <87o91u1idu.fsf@news-spur.riddles.org.uk>
References: <110414461.528890.1563075361778@mail.yahoo.com>
	<1846547624.530883.1563075598322@mail.yahoo.com>
	<CAKFQuwaLmrFiSAOjzcK2-43F-016CZhP5iRpnyzJ0PzsKEgzog@mail.gmail.com>
	<40544440.741577.1563178850210@mail.yahoo.com>
	<CAKFQuwYJsFw9p_qLyashvUmONFZre9OxgEWxDkqdY6-gWB9G7A@mail.gmail.com>
	<768811852.1032981.1563242356010@mail.yahoo.com>
	<CAKFQuwaC_Z24XxjvsSgYPvSNpu+K1Z9_60auVxEpjFQpE5zrFg@mail.gmail.com>
	<774271584.1091322.1563257675315@mail.yahoo.com>
	<1984680550.1098414.1563257845450@mail.yahoo.com>
	<f11f7f05-e3fc-2794-e4ec-4b7144ae56be@stb-datenservice.de>
	<59735533.1068095.1563265280844@mail.yahoo.com>
	<87o91u1idu.fsf@news-spur.riddles.org.uk>




Sent from Yahoo Mail for iPhone


On Tuesday, July 16, 2019, 4:54 PM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:

>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> writes:

 Karen> Can I know which forum to post to cos I think this may be the
 Karen> wrong forum.

This is good enough (though the -general list would probably be better).

But you still need to show us the actual SQL text that gets sent to the
server, NOT just the java code that generates that SQL. You can get the
statement from the server logs (by default, the statement text is logged
alongside any error).
Ok. Thanks. Just to confirm, I need log4j2 or SL4J to generate the log right? 

Please at least make some effort to do that before asking again.

-- 
Andrew (irc:RhodiumToad)

view thread (24+ messages)  latest in thread

Message-ID: <1919398337.1106688.1563269115584@mail.yahoo.com>
Permalink:  ../1919398337.1106688.1563269115584@mail.yahoo.com/
Also on:    postgresql.org/message-id/1919398337.1106688.1563269115584@mail.yahoo.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: karenworld@yahoo.com, andrew@tao11.riddles.org.uk, pgsql-sql@lists.postgresql.org
  Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
  In-Reply-To: <1919398337.1106688.1563269115584@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox