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