[Bucardo-general] bug report - custom code maps

[Grant Maxwell]

It was downloaded via git over the weekend to see if that would fix  
the problem but it didn't. Prior to downloading the git version it was  
version 4 posted as a tar file recently for people who don't have git.

(I now have git)

I've done a bit of work to try and see the problem - without success  
at this stage.

Regards
Grant Maxwell


On 06/09/2009, at 9:53 PM, Greg Sabino Mullane <greg at endpoint.com>  
wrote:

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