Re: [log4perl-devel] Re: MDC and [undef] (was Re: Log::Log4perl::Appender::DBI questions)

[Alex M. <ale...@cl...>]

On Tue, Oct 28, 2003 at 11:08:35PM -0800, Kevin Goess wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> |>it causes problems somewhere else, it's more consistent to just return
> |>undef. Fixed and checked in ...
> |
> | But now it fails with the message :
> |
> | DBD::Pg::st execute failed: ERROR: pg_atoi: zero-length string at
> | /usr/local/lib/perl5/site_perl/5.8.0/Log/Log4perl/Appender/DBI.pm line 96.
> 
> Alex, sorry for the delay.  I'm not reproducing your problem.  The
> following code runs fine, the two MDC columns end up with '' and 0
> respectively.  Does it work for you?  Can you send sample code that
> produces your error?

Hello,

Well, your code produce the same error like mine. Maybe this is a matter
of PostgreSQL version, what's yours ? Mine is 7.3.3.

One can read this in 7.3 release notes :

 "An empty string ('') is no longer allowed as the input into an integer
  field. Formerly, it was silently interpreted as 0."

http://www.postgresql.org/docs/7.3/interactive/release.html#AEN23568

-- 
Alex Marandon
CLARISYS Informatique
http://clarisys.fr