[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