pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Perl Interface is printing NOTICE's on stderr
2+ messages / 2 participants
[nested] [flat]

* Perl Interface is printing NOTICE's on stderr
@ 2000-09-15 14:49 Bryan White <bryan@arcamax.com>
  2000-09-15 19:10 ` Re: Perl Interface is printing NOTICE's on stderr Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Bryan White @ 2000-09-15 14:49 UTC (permalink / raw)
  To: pgsql-interfaces

I have a function that I have added to the database that prints a client
sighon message to the backends log file.  It uses elog(NOTICE...) to write
to the log file.  I routinely call this funct when making a database
connection and it in combination with pids in the log file it is much easier
to correlate client programs with error messages.

My problem is that when the client side is a perl program using the Pg
module, the NOTICE messages are also printed on the client side.  I think
they are going to stderr.

Can someone suggest how to prevent this?

Bryan White





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Perl Interface is printing NOTICE's on stderr
  2000-09-15 14:49 Perl Interface is printing NOTICE's on stderr Bryan White <bryan@arcamax.com>
@ 2000-09-15 19:10 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-09-15 19:10 UTC (permalink / raw)
  To: Bryan White <bryan@arcamax.com>; +Cc: pgsql-interfaces

"Bryan White" <bryan@arcamax.com> writes:
> I have a function that I have added to the database that prints a client
> sighon message to the backends log file.  It uses elog(NOTICE...) to write
> to the log file.
> My problem is that when the client side is a perl program using the Pg
> module, the NOTICE messages are also printed on the client side.  I think
> they are going to stderr.

> Can someone suggest how to prevent this?

Try elog(DEBUG, ...) instead.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-09-15 19:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-15 14:49 Perl Interface is printing NOTICE's on stderr Bryan White <bryan@arcamax.com>
2000-09-15 19:10 ` Tom Lane <tgl@sss.pgh.pa.us>

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