Correct compile error

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

diff --git a/bacula/src/cats/drop_postgresql_tables.in b/bacula/src/cats/drop_postgresql_tables.in
index f59669e6f12527e399c2e83f91f79ba6eb5d92c6..a0da7e391ea4507da4ae122ae5d9f989e4289b34 100644 (file)
--- a/bacula/src/cats/drop_postgresql_tables.in
+++ b/bacula/src/cats/drop_postgresql_tables.in
@@ -3,8 +3,9 @@
 # shell script to delete Bacula tables for PostgreSQL
 
 bindir=@SQL_BINDIR@
+db_name=@db_name@
 
-$bindir/psql -f - -d bacula $* <<END-OF-DATA
+$bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
 drop table unsavedfiles;
 drop table basefiles;
 drop table jobmedia;
@@ -24,7 +25,9 @@ drop table Storage;
 drop table MediaType;
 drop table Status;
 drop table MAC;
+drop table log;
 drop table Location;
+drop table locationlog;
 END-OF-DATA
 pstat=$?
 if test $pstat = 0;