agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: 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:48:55 +0000 (UTC)
Message-ID: <2066139407.1119562.1563270535921@mail.yahoo.com> (raw)
In-Reply-To: <87k1ci1g9u.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>
Sent from Yahoo Mail for iPhone
On Tuesday, July 16, 2019, 5:36 PM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> writes:
>> You can 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.
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
where it is depends 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_collector is _disabled_,
then the logs (if any) are written to wherever the startup script
directed them. This depends on the OS and packaging.
How do you guys use PostgreSQL ? I do not know other ways except PGADMIN4. Is there a tutorial I can read up so that my database that I have created can be access via PostgreSQL?
Last time when my MYSQL was still working, I can just write MySQL d something like that but PostGreSQL I examined the bin there is not command line tool whatsoever....:(
--
Andrew (irc:RhodiumToad)
view thread (24+ messages) latest in thread
Message-ID: <2066139407.1119562.1563270535921@mail.yahoo.com>
Permalink: ../2066139407.1119562.1563270535921@mail.yahoo.com/
Also on: postgresql.org/message-id/2066139407.1119562.1563270535921@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: <2066139407.1119562.1563270535921@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