[Bucardo-general] Bucardo import problem

Greg Sabino Mullane greg at endpoint.com
Wed Feb 3 18:25:11 UTC 2010


> >  KID Warning! Aborting due to exception for public.radcheck.id: 1009
> > Error was DBD::Pg::st execute failed: ERROR:  null value in column
> > "userId" violates not-null constraint at

I was able to duplicate this, and confirmed it was a bug due to the fact 
that the columns in that table were mixedCase. Bucardo was doing the wrong 
thing and casting those to lowercase. The fix will be in the next version 
of Bucardo, but if you want to test it yourself, simply change this command, 
around line 3000 of Bucardo.pm, from:

my $aliaslist = join ',' => map { "$_ AS $g->{cols}[$x++]" } @{$g->{safecols}};

to:

my $aliaslist = join ',' => @{$g->{safecols}};



-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100203/81de8758/attachment.bin 


More information about the Bucardo-general mailing list