Use the command line utility dropdb instead of the psql command

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

diff --git a/bacula/src/cats/update_sqlite_tables.in b/bacula/src/cats/update_sqlite_tables.in
index c841a38a9be7549ed70f1aa9f004c7ed25fcc9f0..3c81697d89de68e0950dbc110f08e6bc43473f56 100755 (executable)
--- a/bacula/src/cats/update_sqlite_tables.in
+++ b/bacula/src/cats/update_sqlite_tables.in
@@ -208,6 +208,7 @@ CREATE TABLE BaseFiles (
 
 COMMIT;
 
-UPDATE Version SET VersionId=7;
+DELETE FROM Version;
+INSERT INTO Version (VersionId) VALUES (7);
 
 END-OF-DATA