From 921aff3e8472f96562cbb4bfa47e59ae7ffad39e Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 20 Sep 2010 16:42:29 +0200 Subject: [PATCH] Fix bug #1623 about indexes that are already created or deleted in postgresql upgrade process. --- bacula/src/cats/update_postgresql_tables.in | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in index f99fd083ff..b6a8e4d798 100644 --- 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 -- 2.39.5