From: Ludwig Isaac Lim <ludz_lim@yahoo.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: print in plpython not appearing in logs
Date: Mon, 5 Dec 2022 02:42:20 +0000 (UTC)
Message-ID: <893661785.901171.1670208140915@mail.yahoo.com> (raw)
In-Reply-To: <2242530.1670077780@sss.pgh.pa.us>
References: <1649936435.214554.1669982358413.ref@mail.yahoo.com>
<1649936435.214554.1669982358413@mail.yahoo.com>
<2242530.1670077780@sss.pgh.pa.us>
Hi Tom:
>> I'm having problems wherein my print() statements inside my plpython stored proc are not appearing in postgresql log. I tried setting the file=sys.stderr
> Hmm. I can tell you that with "logging_collector = on", I would only expect the logs to capture stderr output, not stdout. So it makes
> sense to me that plain "print" would disappear into the bit bucket. But if you specify stderr output, it ought to work. I don't know
> enough Python to know why it's not working, but it seems to me this is primarily a Python question not a Postgres question. Maybe you need
> an explicit fflush-equivalent step? Dunno.
> regards, tom lane
As usual, thank you for pointing out where problem lies.
I made it work by adding flush=True flag to the print() statement.
print("oink oink", file=sys.stderr, flush=True)
I was under the wrong impression that output to stderr are automatically flushed.
Thank you once again.
Regards,
Ludwig
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ludz_lim@yahoo.com
Subject: Re: print in plpython not appearing in logs
In-Reply-To: <893661785.901171.1670208140915@mail.yahoo.com>
References: <1649936435.214554.1669982358413.ref@mail.yahoo.com> <1649936435.214554.1669982358413@mail.yahoo.com> <2242530.1670077780@sss.pgh.pa.us> <893661785.901171.1670208140915@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox