rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/spacewalk-schema.spec | 5 +
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgres | 37 ----------
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgresql | 37 ++++++++++
4 files changed, 42 insertions(+), 39 deletions(-)
New commits:
commit 905d5810bddc36f8c22e5a0eb227fe24ff5fd3cf
Author: Stephen Herr <sherr(a)redhat.com>
Date: Wed Apr 3 17:09:13 2013 -0400
Automatic commit of package [spacewalk-schema] release [1.10.21-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index b17cdcc..17f22ce 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.20-1 schema/spacewalk/
+1.10.21-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index a7429c9..3153c35 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -4,7 +4,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.10.20
+Version: 1.10.21
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Wed Apr 03 2013 Stephen Herr <sherr(a)redhat.com> 1.10.21-1
+- renaming file to correct suffix
+
* Wed Apr 03 2013 Stephen Herr <sherr(a)redhat.com> 1.10.20-1
- Display number of sockets in system details and spacewalk-reports
commit ef063db763e503e89ee3e376b2d98c2f0ced69f8
Author: Stephen Herr <sherr(a)redhat.com>
Date: Wed Apr 3 17:08:59 2013 -0400
renaming file to correct suffix
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgres b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgres
deleted file mode 100644
index f333791..0000000
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgres
+++ /dev/null
@@ -1,37 +0,0 @@
--- oracle equivalent source sha1 66f568e1f6d397f23d2afd412ea60541db81150c
-
-create or replace function get_hw_info_as_clob(
- sid in rhnserver.id%TYPE,
- separator in varchar
-)
-returns text
-as
-$$
-declare
- ret text;
- rec record;
-begin
- for rec in (
- select m
- from (
- select 1 n, sum(nrcpu) || ' CPUs ' || coalesce(to_char(sum(nrsocket), 'FM999'), 'unknown') || ' Sockets' m
- from rhncpu where rhncpu.server_id = sid
- union all
- select 2, ni.name||' '||coalesce(na4.address,'')||'/'||coalesce(na4.netmask,'')||' '||ni.hw_addr val
- from rhnservernetinterface ni,
- rhnServerNetAddress4 na4
- where ni.server_id = sid
- and ni.id = na4.interface_id
- ) X
- order by n, m
- ) loop
- if ret is null then
- ret := rec.m;
- else
- ret := ret || separator || rec.m;
- end if;
- end loop;
- return ret;
-end;
-$$ language plpgsql;
-
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgresql
new file mode 100644
index 0000000..f333791
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/013-get_hw_info_as_clob.sql.postgresql
@@ -0,0 +1,37 @@
+-- oracle equivalent source sha1 66f568e1f6d397f23d2afd412ea60541db81150c
+
+create or replace function get_hw_info_as_clob(
+ sid in rhnserver.id%TYPE,
+ separator in varchar
+)
+returns text
+as
+$$
+declare
+ ret text;
+ rec record;
+begin
+ for rec in (
+ select m
+ from (
+ select 1 n, sum(nrcpu) || ' CPUs ' || coalesce(to_char(sum(nrsocket), 'FM999'), 'unknown') || ' Sockets' m
+ from rhncpu where rhncpu.server_id = sid
+ union all
+ select 2, ni.name||' '||coalesce(na4.address,'')||'/'||coalesce(na4.netmask,'')||' '||ni.hw_addr val
+ from rhnservernetinterface ni,
+ rhnServerNetAddress4 na4
+ where ni.server_id = sid
+ and ni.id = na4.interface_id
+ ) X
+ order by n, m
+ ) loop
+ if ret is null then
+ ret := rec.m;
+ else
+ ret := ret || separator || rec.m;
+ end if;
+ end loop;
+ return ret;
+end;
+$$ language plpgsql;
+