#include "bacula.h"
#include "cats.h"
-#if HAVE_MYSQL || HAVE_SQLITE
+#if HAVE_MYSQL || HAVE_SQLITE || HAVE_POSTGRESQL
/* -----------------------------------------------------------------------
*
mr->VolJobs, mr->VolFiles, mr->VolBlocks, edit_uint64(mr->VolBytes, ed1),
mr->VolMounts, mr->VolErrors, mr->VolWrites,
edit_uint64(mr->MaxVolBytes, ed2), dt,
- mr->VolStatus, mr->Slot, mr->VolumeName, mr->Drive, mr->InChanger);
+ mr->VolStatus, mr->Slot, mr->Drive, mr->InChanger, mr->VolumeName);
Dmsg1(400, "%s\n", mdb->cmd);
void
db_make_inchanger_unique(JCR *jcr, B_DB *mdb, MEDIA_DBR *mr)
{
- if (mr->InChanger != 0) {
+ if (mr->InChanger != 0 && mr->Slot != 0) {
Mmsg(&mdb->cmd, "UPDATE Media SET InChanger=0 WHERE PoolId=%u "
"AND Slot=%d\n", mr->PoolId, mr->Slot);
Dmsg1(400, "%s\n", mdb->cmd);
}
}
-#endif /* HAVE_MYSQL || HAVE_SQLITE */
+#endif /* HAVE_MYSQL || HAVE_SQLITE || HAVE_POSTGRESQL*/