schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
| 1 +
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
| 1 +
2 files changed, 2 insertions(+)
New commits:
commit 6114a074ed003ea4c8da19e055578f72469c83ec
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 19:18:53 2013 +0100
We need to drop rhn_download_id_seq as well.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
index 7b30871..298e2e5 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnDownloads-drop.sql
@@ -2,4 +2,5 @@
drop table rhnChannelDownloads;
drop table rhnDownloads;
drop table rhnDownloadType;
+drop sequence rhn_download_id_seq;
commit 68d4f302ac7221008925e7458d1d040b61c9b11e
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Jan 22 19:16:34 2013 +0100
We need to recreate the view from scratch.
Addressing
psql:/var/log/spacewalk/schema-upgrade/20130122-125951-script.sql:5630: ERROR: cannot
change name of view column "last_checkin_days_ago" to "crash_count"
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
index c6fdf75..1321fb6 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/006-rhnServerOverview.sql
@@ -1,3 +1,4 @@
+drop view rhnServerOverview;
create or replace view
rhnServerOverview
(
Show replies by date