Fix bug #1623 about indexes that are already created or deleted in postgresql upgrade...

diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
index f99fd083ff605a284aa90da979f83fadef6ae46d..b6a8e4d7984af8213c07e5ca15b6badfa5aae631 100644 (file)
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -61,6 +61,9 @@ COMMIT;
 
 CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );
 
+-- suppress output for index modification
+SET client_min_messages TO 'fatal';
+
 -- Remove bad PostgreSQL index
 DROP INDEX file_fp_idx;
 
@@ -71,6 +74,9 @@ DROP INDEX file_fp_idx;
 
 CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId);
 
+-- restore output
+SET client_min_messages TO DEFAULT;
+
 ANALYSE;
 
 END-OF-DATA