Re: DBD::Pg 1.30_1 WAS (Re: Prepare and prepare ?)

From: Dominic Mitchell <dom(at)semantico(dot)com>
To: David Wheeler <david(at)wheeler(dot)net>
Cc: Rudy Lippan <rlippan(at)remotelinux(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-interfaces(at)postgresql(dot)org, 'DBI developers' <dbi-dev(at)perl(dot)org>
Subject: Re: DBD::Pg 1.30_1 WAS (Re: Prepare and prepare ?)
Date: 2003-05-29 15:44:10
Message-ID: 3ED62ACA.90307@semantico.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

David Wheeler wrote:
> On Thursday, May 29, 2003, at 02:00 AM, Dominic Mitchell wrote:
>
>> One more thing for the change log: notice messages generated by the
>> database now use the perl warning mechanism instead of going to
>> stderr, so they can be trapped if needed.
>
>
> Oh, sweet! How did you do that? I've been doing this to catch them:
>
> <hack caveat="ugly">
>
> open STDERR, "| perl -ne 'print unless /: NOTICE: /'"
> or die "Cannot pipe STDERR: $!\n";
>
> </hack>

Just hook up the existing libpq function PQsetNoticeProcessor() to a
XS's warn in dbdimp.c. It's about 5 lines of code. I don't know
whether it's 100% correct (I'm no XS guru), but it Works For Me[tm].

-Dom

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jeff Silberberg 2003-05-30 01:51:51 Maybe Off Topic -- PGACCESS
Previous Message David Wheeler 2003-05-29 15:36:28 Re: DBD::Pg 1.30_1 WAS (Re: Prepare and prepare ?)