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

[Mark Wong]

Hi all,

I'm having a problem with the add sync command, specifically:

	bucardo_ctl add sync as type=pushdelta source=a targetdb=s1

I'm trying this on Ubuntu 8.04, with PostgreSQL 8.3, DBI 1.609, DBD:Pg  
2.16.1, DBIx::Safe 1.2.5.

 From the following log snippet, it looks like validate_sync()  
triggered by the INSERT into the bucardo.sync causes an error on the  
CREATE INDEX statement.  What is appearing to happen is that the  
CREATE INDEX actually completes despite the error, and the ROLLBACK  
undoes the INSERT into bucardo.sync but doesn't remove the index.

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
2010-01-26 21:31:15 CST 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 LOG:  statement: ROLLBACK


Am I understand what is going on correctly? Let me know if there is  
any more information I can provide.

Regards,
Mark Wong