From ba34f0c20ba20d406f76c72aafcbdf5cf0490995 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 20 Sep 2010 16:41:07 +0200 Subject: [PATCH] Fix bug #1623 about indexes that are already created or deleted in postgresql upgrade process. --- bacula/updatedb/update_postgresql_tables_11_to_12.in | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/bacula/updatedb/update_postgresql_tables_11_to_12.in b/bacula/updatedb/update_postgresql_tables_11_to_12.in index 51e9f7bcd6..35f294ed9e 100644 --- a/bacula/updatedb/update_postgresql_tables_11_to_12.in +++ b/bacula/updatedb/update_postgresql_tables_11_to_12.in @@ -70,6 +70,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; @@ -80,9 +83,10 @@ DROP INDEX file_fp_idx; CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId); -ANALYSE; +-- restore output +SET client_min_messages TO DEFAULT; -UPDATE Version SET VersionId=12; +ANALYSE; END-OF-DATA then -- 2.39.5