[Bucardo-general] bug report - custom code maps

[Grant Maxwell]

Hi

Having created a custom code segment I want to attach it to a sync.  
The problem is that the goat field cannot be null when I specify the  
sync name, but also wont accept a value.

If sync field is used  the record can't be saved.

error message examples below.

SQL error:

ERROR:  new row for relation "customcode_map" violates check  
constraint "customcode_map_syncgoat"
In statement:
INSERT INTO "bucardo"."customcode_map" ("code", "sync", "goat",  
"active", "priority", "cdate") VALUES ('3', 'mailaddresses_t2', 0,  
FALSE, 0, now())



SQL error:

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())



SQL error:

ERROR:  new row for relation "customcode_map" violates check  
constraint "customcode_map_syncgoat"
In statement:
INSERT INTO "bucardo"."customcode_map" ("code", "sync", "goat",  
"active", "priority", "cdate") VALUES ('3', 'mailaddresses_t2', '143',  
TRUE, 0, now())

regards

Grant


-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090905/45e57dd9/attachment.html