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:[email protected] _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
