From cde5db89e2cf65145eaed1c8353e91e802875370 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Wed, 7 Nov 2012 16:03:46 +0100 Subject: [PATCH] Fix missing index on Media table --- bacula/src/cats/make_postgresql_tables.in | 3 ++- bacula/src/cats/update_postgresql_tables.in | 3 +++ 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index cb8d58dd6d..9e570880b1 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -219,7 +219,8 @@ CREATE TABLE media primary key (mediaid) ); -create unique index media_volumename_id on media (volumename); +CREATE UNIQUE INDEX media_volumename_id ON Media (VolumeName); +CREATE INDEX media_poolid_idx ON Media (PoolId); CREATE TABLE MediaType ( diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in index d737bcf35a..f97cb60007 100644 --- a/bacula/src/cats/update_postgresql_tables.in +++ b/bacula/src/cats/update_postgresql_tables.in @@ -45,6 +45,9 @@ ALTER TABLE File ADD COLUMN DeltaSeq smallint default 0; UPDATE Version SET VersionId=14; COMMIT; +set client_min_messages = fatal; +CREATE INDEX media_poolid_idx on Media (PoolId); + ANALYSE; END-OF-DATA -- 2.39.2