| From: | Tyler MacDonald <tyler(at)yi(dot)org> | 
|---|---|
| To: | "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com> | 
| Cc: | pgsql-general(at)postgresql(dot)org, dbi-users(at)perl(dot)org | 
| Subject: | Re: Any way to make PG driver obey PrintWarn? | 
| Date: | 2006-02-06 23:47:39 | 
| Message-ID: | 20060206234738.GU9232@yi.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Uwe C. Schroeder <uwe(at)oss4u(dot)com> wrote:
> Probably because the notice you see is a notice from the database engine,
> not from the driver.  
	OK, but in order for them to get to my tty, they have to bubble down
from postgres, through the UNIX/TCP socket I am talking to the driver with,
into DBD::Pg, through DBI, and out through perl's STDERR right? I mean, that
must be right, because if I run my script "2> /dev/null" I don't see this
spam... so it would stand to reason that if DBI provides a "PrintWarn"
option that "controls the printing of warnings recorded by the driver.  When
set to a true value the DBI will check method calls to see if a warning
condition has been set."... 
	So it sounds like DBD::Pg isn't thinking to squealch NOTICEs coming
from the server when I ask it to by turning PrintWarn off.
> You can however turn off those notices in postgresql.conf
	Sure I can, or I can do "SET client_min_messages=error", but
shouldn't the DBD::Pg driver do that *for* me when I ask not to see
warnings?
	Thanks,
		Tyler
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tyler MacDonald | 2006-02-06 23:49:36 | Re: Should I use PL/PGSQL or Perl/PGSQL? | 
| Previous Message | Merlin Moncure | 2006-02-06 23:42:53 | Re: Should I use PL/PGSQL or Perl/PGSQL? |