Fix syntax of renaming postgresql per Dan.

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1683 91ce42f0-d328-0410-95d8-f526ca767f89

diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
index 396e3a5a12c190cb73875d17c818c61d7e500816..8739ffce6ae34518d09d433d5226559973c5c5d2 100755 (executable)
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -21,11 +21,11 @@ ALTER TABLE media ALTER COLUMN EndBlock SET NOT NULL;
 
 UPDATE Filename SET Name='' WHERE Name=' ';
 
-alter table file alter column filenameid rename to filenameid-old;
+alter table file rename column filenameid to filenameidold;
 alter table file add column filenameid integer;
-update file set filenameid = filenameid-old;
+update file set filenameid = filenameidold;
 alter table file alter column filenameid set not null;
-alter table file drop column filenameid-old;
+alter table file drop column filenameidold;
 
 DELETE FROM Version;
 INSERT INTO Version (VersionId) VALUES (8);