- Fix altering PostgreSQL table to be compatible with version 7.3.

[bacula/bacula] / bacula / src / cats / update_postgresql_tables.in

diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
index 873e063b3cf12e65f41e56c8a7ab0235ac05a81f..396e3a5a12c190cb73875d17c818c61d7e500816 100755 (executable)
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -21,7 +21,11 @@ ALTER TABLE media ALTER COLUMN EndBlock SET NOT NULL;
 
 UPDATE Filename SET Name='' WHERE Name=' ';
 
-ALTER TABLE file ALTER COLUMN filenameid SET integer;
+alter table file alter column filenameid rename to filenameid-old;
+alter table file add column filenameid integer;
+update file set filenameid = filenameid-old;
+alter table file alter column filenameid set not null;
+alter table file drop column filenameid-old;
 
 DELETE FROM Version;
 INSERT INTO Version (VersionId) VALUES (8);
@@ -38,6 +42,8 @@ create table CDImages
    primary key (MediaId)
 );
 
+vacuum;
+
 END-OF-DATA
 then
    echo "Update of Bacula PostgreSQL tables succeeded."