Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnJiH-0003rx-Hl for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 09:25:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnJiG-0008Fh-5m for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 09:25:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnJiF-0008CF-OP for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 09:25:31 +0000 Received: from sonic303-1.consmr.mail.bf2.yahoo.com ([74.6.131.40]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hnJi8-0005Gm-Ph for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 09:25:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563269121; bh=PqyGF3m0bi2mG9vFb9TqCv2oKqW/+64NIrkVUNbDX8g=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=R/wpP/H/Msl9sCkEEQUi4kQ/hlA0vseafo/G/6C4d4GjP/TpGWWMLbkiSU58tYMLcpMLwAUq9h2gNizim7147ZBH0QwfZc+TBfJWAfOrnaHU6jnJTqwdgwTgAkK+u7ltj0XrPpA5BKkHSLWE68BzytA3WLcKF7+SL6Z25NCKzdz3B/wubvqeEtJlbVKZeZLTW3CkLMFbiy8Gon7Id5GKVjTVl20AzOelNmCF27Fntjb1Xk2Iu0CRec8P5/ram9TEq2wmtxz2hgSlTUEgwYme65L3QGfKwudU69fIVovjdORzTMkQCxd1ResExRIXcOwtCXYelbinp5jC6yps5tXUBQ== X-YMail-OSG: z7KHiHEVM1k6A_olYS2kvkuC_iNdnqNmFl7ggY.GjLjfn7LShsxkkSgYflGww5I XtsSucz6E7ANAwhipcSs3sV.x.XrHuShzcDUBcJx1cImBUc7tT5AtPROTiEc6c1N4dR0_klJ6tG6 FvDBqH7r45dxerYDOtEAfY2BfjIo9BwoT.mFurfWn2I979.GhsbHlSi.Y2s30NRVvBZL33.XdQ7n Y2V__O9VtUrcLC3ppGR6xiYHvgunVBUDXZq7bsvcYKqXTBXzMuSEVTVQx4WO55QTsG0We6v4r9ET Iuk4yVEV7nsQVeHl29gyJUgsL4JeM3YoA4UFof1YdxxpMBf_ZALAzwNm.0fAF6IwINtwbxcpYkEi ZY9b82PCELHjz8eyalEBiL1coEy.J0XzqYOvc64HHG5BTeLJRBRRAB0W8nX5ZhZKZgYwp4LBVHXN USAb6OmLCZ62NKRQSJ1_E08uZjlRypHET3fyp76xGBobtldic0Xs8MPie68sfr1bjkPbGvqwCuqh 6Ql0uDM5jB9HDAi4cQbr3zyIUOJo8XnipE24zHmIb2PS8DEpZ5PoQMH9GyWhhtf7NiKzd6qvO42Q kfNCik5xmAyMuEdvd8_CRoJhs.QvNnEJvvkaHaX7VqLl0dw4GvELNP3pnMJN0e9UW9083D33Hzz6 sFhs73cQzanl.hte5TjmR7t3aEjhadzVZu8GDfO5FtBKFlo8gFjT0xxi7uekfN80_vCQQtX_U3q9 CHDarX67FDYwBDtRxZT8fA7rLbNBCTmeo6LS6dQryG9PPaGaHkgYqsi9Q5QiKfjXnyRS99F7Ijkl 02rxmUg.nSqIU1OgkOtzgBZbX2ul4ecJc6rvzUUp3nPqvlonBYSrDFFluGnmFdi8KjT47bBZVBel V_Qj_ahTSu4rsV5XNHxUFDbPvhi9afENyaf2A8LvKbEP23mnCN5lf6qMIf33q3r2S.L56SLX4DTZ ZVGVwSFhEV9m9xWcteDfRKSQnGxP2Sjt_gQ5vaiL_WMBZmFLnpreR82v970KvvvvnosI8jWiTYdI d2Lkv48BulEY9j916ebeTZ.iDKIFNitVQB_jXiHClQTj4G0bq7YJ1C.Wzds6fQHFLYtbrUoUxNz8 owH6PYYAW.Tr6vxBISN0OhaH0Ru_0XfUn1Ddl75FkYwTqNKssDuY7QOWwnOq5TDuAsgzRy6BFt50 CRkcL9eTHSVxn6g7b.nbgVu5.zZtSqbO7Vr2K_u8FByP5X2uzX_aOx0d3JL85QnkiULCiS1wDdGm eEBk2_5mpQiYFMvw4jUUARiiDuHXmWIBaQsHrV6ZKFtrQ9OcpLwPLqNKK7Mr7kj.fKb_. Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Tue, 16 Jul 2019 09:25:21 +0000 Date: Tue, 16 Jul 2019 09:25:15 +0000 (UTC) From: Karen Goh To: Andrew Gierth Cc: Message-ID: <1919398337.1106688.1563269115584@mail.yahoo.com> In-Reply-To: <87o91u1idu.fsf@news-spur.riddles.org.uk> References: <110414461.528890.1563075361778@mail.yahoo.com> <1846547624.530883.1563075598322@mail.yahoo.com> <40544440.741577.1563178850210@mail.yahoo.com> <768811852.1032981.1563242356010@mail.yahoo.com> <774271584.1091322.1563257675315@mail.yahoo.com> <1984680550.1098414.1563257845450@mail.yahoo.com> <59735533.1068095.1563265280844@mail.yahoo.com> <87o91u1idu.fsf@news-spur.riddles.org.uk> Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1106687_819297661.1563269115583" X-Mailer: WebService/1.1.13991 YahooMailIosMobile Yahoo%20Mail/45955 CFNetwork/978.0.7 Darwin/18.6.0 Content-Length: 3028 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1106687_819297661.1563269115583 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sent from Yahoo Mail for iPhone On Tuesday, July 16, 2019, 4:54 PM, Andrew Gierth wrote: >>>>> "Karen" =3D=3D Karen Goh 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 righ= t?=C2=A0 Please at least make some effort to do that before asking again. --=20 Andrew (irc:RhodiumToad) ------=_Part_1106687_819297661.1563269115583 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


Sent fr= om Yahoo Mail for iPhone

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

>>&g= t;>> "Karen" =3D=3D Karen Goh <karenworld@yaho= o.com> writes:

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

This is good e= nough (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 gen= erates that SQL. You can get the
statement from the serve= r logs (by default, the statement text is logged
alongsid= e 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 th= at before asking again.

--
Andrew (irc:RhodiumToad)

------=_Part_1106687_819297661.1563269115583--