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

Greg Sabino Mullane greg at endpoint.com
Wed Feb 3 16:36:44 UTC 2010

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.

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100203/0e8b8e0b/attachment.bin 

More information about the Bucardo-general mailing list