[Bucardo-general] bug report - custom code maps

Greg Sabino Mullane greg at endpoint.com
Sun Sep 6 11:53:50 UTC 2009


> ERROR:  invalid input syntax for integer: ""
> In statement:
> INSERT INTO "bucardo"."customcode_map" ("code", "sync", "goat",
> "active", "priority", "cdate") VALUES ('3', 'mailaddresses_t2', '',
> TRUE, 0, now())

Again, this fails because you are setting an empty string for the goat
column, which will not work - it needs to be NULL or a valid number
(goat.id) from the goat table.

> INSERT INTO "bucardo"."customcode_map" ("code", "sync", "active",
> "priority", "cdate") VALUES ('3', 'mailaddress_t2', TRUE, 0, now());
> 
> ERROR:  null value in column "goat" violates not-null constraint

This is odd - what version of Bucardo is this?


-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090906/4090bb97/attachment.bin 


More information about the Bucardo-general mailing list