bat: Use BVFS on bRestore view

[bacula/bacula] / bacula / src / cats / fix_postgresql_tables

diff --git a/bacula/src/cats/fix_postgresql_tables b/bacula/src/cats/fix_postgresql_tables
index 4d835df68ee23894e22415988cfeaf333e7f963d..2d69f89278089a665e940680551d0948d23576d2 100755 (executable)
--- a/bacula/src/cats/fix_postgresql_tables
+++ b/bacula/src/cats/fix_postgresql_tables
@@ -14,11 +14,15 @@ bindir=****EDIT-ME to be the path to psql****
 if $bindir/psql $* -f - <<END-OF-DATA
 \c bacula
 
-alter table media alter column endblock rename to endblock-old;
+begin;
+
+alter table media rename column endblock to endblock_old;
 alter table media add column endblock bigint;
-update media set endblock = endblock-old;
+update media set endblock = endblock_old;
 alter table media alter column endblock set not null;
-alter table media drop column endblock-old;
+alter table media drop column endblock_old;
+
+commit;
 
 vacuum;