From 983822380cfb6b6ffd76285c4f92532576ae66e5 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Mon, 5 Oct 2009 15:34:26 +0200
Subject: [PATCH] Fix postgresql MD5 missing field

---
 bacula/src/cats/sql_cmds.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c
index f6536f167f..ddd035a941 100644
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -571,7 +571,7 @@ const char *select_recent_version[4] = {
 
    /* Postgresql */
    "SELECT DISTINCT ON (FilenameId, PathId) StartTime, JobId, FileId, "
-          "FileIndex, PathId, FilenameId, LStat "
+          "FileIndex, PathId, FilenameId, LStat, MD5 "
      "FROM File JOIN Job USING (JobId) "
     "WHERE JobId IN (%s) "
     "ORDER BY FilenameId, PathId, StartTime DESC ",
-- 
2.39.5