[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