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 1hnK5A-0004gp-Qj for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 09:49:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnK58-0001W7-Oi for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 09:49:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnK58-0001PM-GH for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 09:49:10 +0000 Received: from sonic308-1.consmr.mail.bf2.yahoo.com ([74.6.130.40]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnK53-0000Dl-5U for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 09:49:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563270542; bh=IL8jyvtHKkoOXwmbSwJd0lLSqhh1XaTfa8+3/Hg7xg8=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=NnEceOKG56KHZILbXu1JtvEQ5jbL79k8x6k2q5C0PNL13UkVEsj0Av6uxlaCteH8zpx36b/Z2rt2lnn7TSWkJ6eSRClI4/LIcbk5rh8S+RdpPWKzvooh2gqT/IpG+RAptPty85fPLtEABR7SRumV8QJoXpl8kjFJKqNzR+Rs4qG4YsisQgabuzTpwndNCSYdbYwu15UZhTZIWClPjyeyQdN/23OqfPpICeGIy3Q3CDrj3BDulk/OppspVvVYzFCMZNklQI30GJmpjTS5xp8o1JwPP+6/7tqOYdhC7vV0TRLRKOde9cGoCmOU9/SKaulrOCcYeyxQcpzMFHZfAJNRWA== X-YMail-OSG: DB2KjhQVM1nEUiV1RPHAsevYw14.QcVZ.EIWFSG_cQcwttb_yVRBj9tcxOvdiLo yBfIR6GwhLxpmjOBTJV4uVU91Er9e3qg1BstnzYk.VRIjoSDPbifZ4p.xPuNtWj8Ngy0wOWRRnEv E0r6jHpglkC5Gx2g0Vp62CeBkaWirOpfpr6D6SdTYL_adQOqVzAhHCw8jOaKFfnZU_Sipu_.OrPQ MbFjuHwRJsb70Xk8Jc9r5zucZV5nrO88vrwGzZslFSnFaAQBWEy5oQcIw2IY1jBNUql9YH7uzRxU aSUEKQs8VH.ELpeNISlCAdBmNTXxlkUJoPdTMotOQFyRutzKBMLkRI5CxN.q2csh8.Kcw_WReqqz LiEvrHvHuK7CM2vHv2ozBKFD1NbgZbCrwgAQobsiF1FE4niuhBymbLvliBkjPzhOb9pwBqNcF_7L zbajfo921DHO4QBy7M.vO7I_YPdxNOWd.E1JTPrfpApweNU43wRtbIToumRnyHnp9Z81tuRgaNHI bWOW8NMCJnjbSlFRsqadFd0tahWfT74tWUHCJ0SKNvl0qAtciDBRELqVOe5rEk3SZO_gH1SmbWiH FBPEWbWuQy7bC9dNlZhELfCv.Vu7s1KxsYUrGnbSh16NE_LkBkvZPcZW9gFjErx04AfL5Idz9c9H dvxDsdSOQLweZfo.Hy_vV6jEwGdFDZjNSAse8ut8viHMbK_8M.HoTLTwpb9nn1G4XvEzvAYP38mO 4v_ICrfOIPz9Sv8ATLCknAX5UB41kKK4ItjZ16POoQVg61AXeqz5r43JmgisCjlozSAZovMw0uk8 QHD1Dr0ii4BE1fHgEwHJfx6f_bwbkxRnluPZLOtPxNkRjdmqs__GzFGctO8B7s5_7LPHCDcPfnRf latrq1cNyDUIXNRrZGxw_43CLIRT2qWP2MqbnpvKYvtgqcPtiTyipYnWNj24QC7AqU2.kZuBjo_7 4XtzLHdfrYzO2gm6ySQKxkl4wj_txyHqmuKPBRYHo5j1vmAspGGYL2i5Mc2an_IgEuikq_smpwsQ yEieoMlYwJywuubp6EPIaLQT09QggFDtV1n87.NCZ8up44VdjRdizigjnkFcmrJ8yGkaNGckMHLg mKNTDuje2sOye5xA2RZotDwGEmpU8PSzk0mm7LPAk9mPxC0RlQ0Pq9JBthiHD9m7AxCm3rr_6V6W evde7VHfOQsXOGSSKJ2TTR1J5y7jS3JahGZp_xgEDAL0_fL19.C2lOKp.dqNAfb5IDo6qt0_7TfV UJA57o7z4h2sar5Yu4Dac3VjyfK6PnXNDMPEP6x2sFIzNbRwiMhqqf136mSpOX9X1jg-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.bf2.yahoo.com with HTTP; Tue, 16 Jul 2019 09:49:02 +0000 Date: Tue, 16 Jul 2019 09:48:55 +0000 (UTC) From: Karen Goh To: Andrew Gierth Cc: Message-ID: <2066139407.1119562.1563270535921@mail.yahoo.com> In-Reply-To: <87k1ci1g9u.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> <1919398337.1106688.1563269115584@mail.yahoo.com> <87k1ci1g9u.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_1119561_847294285.1563270535920" X-Mailer: WebService/1.1.13991 YahooMailIosMobile Yahoo%20Mail/45955 CFNetwork/978.0.7 Darwin/18.6.0 Content-Length: 5642 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1119561_847294285.1563270535920 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sent from Yahoo Mail for iPhone On Tuesday, July 16, 2019, 5:36 PM, Andrew Gierth wrote: >>>>> "Karen" =3D=3D Karen Goh writes: >> You can get the statement from the server logs (by default, the >> statement text is logged alongside any error). =20 Karen> Ok. Thanks. Just to confirm, I need log4j2 or SL4J to generate Karen> the log right? No. PostgreSQL writes its own logs. Most installs have some degree of logging enabled by default, though this does depend on what package was installed and how the server was started. In some cases you can figure out where the log files are from the following server settings (use the SHOW statement to display them): 1. If log_destination is "syslog", then whether a log file exists and =C2=A0 where it is depends on the system's syslog.conf file. 2. If log_destination is "eventlog", then this is a Windows system, and =C2=A0 log messages are in the Windows event log. 3. If log_destination is neither of the above, and logging_collector is =C2=A0 enabled, then the log_directory setting shows where the log files ar= e =C2=A0 (if this is a relative path, it's relative to data_directory). 4. If log_destination is "stderr" and logging_collector is _disabled_, =C2=A0 then the logs (if any) are written to wherever the startup script =C2=A0 directed them. This depends on the OS and packaging. How do you guys use PostgreSQL ? I do not know =C2=A0other ways except PGAD= MIN4. Is there a tutorial I can read up so that my database that I have cre= ated can be access via PostgreSQL?=C2=A0 Last time when my MYSQL was still working, I can just write MySQL d somethi= ng like that but PostGreSQL I examined the bin there is not command line to= ol whatsoever....:( --=20 Andrew (irc:RhodiumToad) ------=_Part_1119561_847294285.1563270535920 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, 5:36 PM, Andrew Gierth <andrew@tao11.riddles.org.= uk> wrote:

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

>> You ca= n get the statement from the server logs (by default, the
>> statement text is logged alongside any error).

Karen> Ok. Thanks. Just to confirm, I need log4j2 = or SL4J to generate
Karen> the log right?

No.

PostgreS= QL writes its own logs. Most installs have some degree of
logging enabled by default, though this does depend on what package wasinstalled and how the server was started. In some cases you= can figure
out where the log files are from the followin= g server settings (use the
SHOW statement to display them= ):

1. If log_destination is "syslog", = then whether a log file exists and
  where it is de= pends on the system's syslog.conf file.

2. If log_destination is "eventlog", then this is a Windows system, and  log messages are in the Windows event log.

3. If log_destination is neither of the above= , and logging_collector is
  enabled, then the log_= directory setting shows where the log files are
  (= if this is a relative path, it's relative to data_directory).

4. If log_destination is "stderr" and logging_colle= ctor is _disabled_,
  then the logs (if any) are wr= itten to wherever the startup script
  directed the= m. This depends on the OS and packaging.


How do you guys use Post= greSQL ? I do not know  other ways except PGADMIN4. Is there a tutoria= l I can read up so that my database that I have created can be access via P= ostgreSQL? 

Last time when my MYSQL = was still working, I can just write MySQL d something like that but PostGre= SQL I examined the bin there is not command line tool whatsoever....:(

--
Andrew (irc:RhodiumT= oad)


------=_Part_1119561_847294285.1563270535920--