Date: Tue, 16 Jul 2019 14:19:40 +0000 (UTC)
From: Karen Goh <karenworld@yahoo.com>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: pgsql-sql@lists.postgresql.org
Message-ID: <274777029.1154161.1563286780671@mail.yahoo.com>
In-Reply-To: <875zo213dq.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>
 <1919398337.1106688.1563269115584@mail.yahoo.com>
 <87k1ci1g9u.fsf@news-spur.riddles.org.uk>
 <2066139407.1119562.1563270535921@mail.yahoo.com>
 <87d0ia1bmt.fsf@news-spur.riddles.org.uk>
 <1787690642.1167081.1563281149734@mail.yahoo.com>
 <875zo213dq.fsf@news-spur.riddles.org.uk>
Subject: Re: how to resolve org.postgresql.util.PSQLException: ERROR:
 operator does not exist: text = integer?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1154160_307275577.1563286780670"
Content-Length: 3063
Precedence: bulk

------=_Part_1154160_307275577.1563286780670
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

 
On Tuesday, July 16, 2019, 10:11:13 PM GMT+8, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:


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

Karen> Do you mind tell me where do I download PostgreSQL? I am using
Karen> Windows 10 as OS.

https://www.postgresql.org/download/windows/

This links to the EnterpriseDB installer package, which is the one you
want (so it'll take you to the EnterpriseDB site).

(But I have to ask, is this part of some actual plan to solve your
original problem? You clearly already have a postgresql server that you
are connecting to, otherwise you wouldn't get that error.)

Yes. I have downloaded and it is inside my Program Files. Hence, I wonder where to check the log you have mentioned. 
Can you tell me where to look for the server ?
And now I am getting another error :

org.postgresql.util.PSQLException: ERROR: operator does not exist: text = character varying[]

 Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
 Position: 69

But, I check stackoverflow, it is mentioned that text is the best definition. And this is what I used for subject_name which is a list I am getting from the In clause.


-- 
Andrew (irc:RhodiumToad)


------=_Part_1154160_307275577.1563286780670
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>                <br><br><br><br><br>On Tuesday, July 16, 2019, 10:11:1=
3 PM GMT+8, Andrew Gierth &lt;andrew@tao11.riddles.org.uk&gt; wrote:<br><br=
><br>&gt;&gt;&gt;&gt;&gt; &quot;Karen&quot; =3D=3D Karen Goh &lt;karenworld=
@yahoo.com&gt; writes:<br><br>Karen&gt; Do you mind tell me where do I down=
load PostgreSQL? I am using<br>Karen&gt; Windows 10 as OS.<br><br>https://w=
ww.postgresql.org/download/windows/<br><br>This links to the EnterpriseDB i=
nstaller package, which is the one you<br>want (so it&#39;ll take you to th=
e EnterpriseDB site).<br><br>(But I have to ask, is this part of some actua=
l plan to solve your<br>original problem? You clearly already have a postgr=
esql server that you<br>are connecting to, otherwise you wouldn&#39;t get t=
hat error.)<br><br>Yes.  I have downloaded and it is inside my Program File=
s.  Hence, I wonder where to check the log you have mentioned.  <br>Can you=
 tell me where to look for the server ?<br>And now I am getting another err=
or :<br><br>org.postgresql.util.PSQLException: ERROR: operator does not exi=
st: text =3D character varying[]<br><br>  Hint: No operator matches the giv=
en name and argument type(s). You might need to add explicit type casts.<br=
>  Position: 69<br><br>But, I check stackoverflow, it is mentioned that tex=
t is the best definition.  And this is what I used for subject_name which i=
s a list I am getting from the In clause.<br><br><br>-- <br>Andrew (irc:Rho=
diumToad)<br><br><br>            </div>           =20
------=_Part_1154160_307275577.1563286780670--