[Bucardo-general] bug report - custom code maps

[Grant Maxwell]

Nah it still does not work - my examples included one were the goat  
column was set to null. (provided again below)

error message examples below.

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



Even using psql to insert the record will not work. I suspect it might  
relate to the fact that the goat field is a foreign key for a field  
which has a non-null constraint in the primary table (goats) .



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



On 05/09/2009, at 9:36 PM, Greg Sabino Mullane wrote:

>> 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())
>
> You are setting the goat column to 0, but you need to set it to null:
>
> INSERT INTO bucardo.customcode_map (code,sync,goat,active)
> VALUES (3,'mailaddresses_t2',NULL,FALSE);
>
> -- 
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090906/2ff1548d/attachment.html