[Bucardo-general] Bug with customcols in 4.999.4

[rivantsiv+bucardo at gmail.com]

Hello all,

Found 2 problems with customcols.

1.) When you add customcols with
bucardo add customcols <tablename> "SELECT ..."
for quoted columns you have to specify \", like this:

bucardo add customcols Events "SELECT \"EventGUID\", \"EventName\", \"Date\", \"PrivacyProtected\",\
\"Edited\", \"Editor\", \"EditedDate\", \"SymLinkOriginal\", \"SymLinkBig\",\
\"LocationFacility\", \"LocationMark\""

otherwise  quotes  are not added. Maybe this is not very convenient an
can be fixed.


2.) A real bug
When  you  specify the db with db=<dbname> custom columns stop working
and are ignored

like
bucardo add customcols Events "SELECT \"EventGUID\", \"EventName\", \"Date\", \"PrivacyProtected\",\
\"Edited\", \"Editor\", \"EditedDate\", \"SymLinkOriginal\", \"SymLinkBig\",\
\"LocationFacility\", \"LocationMark\"" db=local

will not work

while
bucardo add customcols Events "SELECT \"EventGUID\", \"EventName\", \"Date\", \"PrivacyProtected\",\
\"Edited\", \"Editor\", \"EditedDate\", \"SymLinkOriginal\", \"SymLinkBig\",\
\"LocationFacility\", \"LocationMark\""

works.

As soon as you set column db in customcols to NULL, it works.



  

-- 
Best regards,
 Rivantsiv+bucardo                          mailto:rivantsiv+bucardo at gmail.com