[Bucardo-general] v4.4.0 fails to add sync

[Mark Wong]

On Feb 3, 2010, at 10:36 AM, Greg Sabino Mullane wrote:

> On Wed, Jan 27, 2010 at 10:51:50AM -0800, Mark Wong wrote:
>> Hi all,
>>
>> I'm having a problem with the add sync command, specifically:
>>
>> 	bucardo_ctl add sync as type=pushdelta source=a targetdb=s1
> ...
>> 2010-01-26 21:31:15 CST LOG:  statement: CREATE INDEX
>> "bucardo_delta_public_fruit_vote_rowid" ON
>> bucardo.bucardo_delta((rowid::text),(rowid2::time)) WHERE tablename =
>> 18297
>> 2010-01-26 21:31:15 CST ERROR:  functions in index expression must be
>> marked IMMUTABLE
>
> We can't create an index on a column of type "time" as it can change
> based on things like datestyle. I'll look into a Bucardo workaround,  
> but you
> may need to change your column definition or use a different primary
> key for that table.

Ah, ok.  Thanks for the explanation.

Regards,
Mark Wong