rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/oracle/triggers/rhnContentSourceSsl.sql | 2 +-
schema/spacewalk/postgres/triggers/rhnContentSourceSsl.sql | 8 ++++----
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.oracle | 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.postgresql | 8 ++++----
6 files changed, 15 insertions(+), 12 deletions(-)
New commits:
commit aee29e680f3323151c6eef016aeaa366e7349af2
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Jan 23 11:31:22 2013 +0100
Automatic commit of package [spacewalk-schema] release [1.9.17-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 4a68194..b641793 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.9.16-1 schema/spacewalk/
+1.9.17-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index f211c70..a31ea7a 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -2,7 +2,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.9.16
+Version: 1.9.17
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -68,6 +68,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Wed Jan 23 2013 Jan Pazdziora 1.9.17-1
+- Avoid exceeding maximal identifier length.
+
* Tue Jan 22 2013 Jan Pazdziora 1.9.16-1
- We need to drop rhn_download_id_seq as well.
- We need to recreate the view from scratch.
commit a10b37c840b933f1130bab07fe7bfa76b5c0eae5
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Wed Jan 23 11:30:11 2013 +0100
Avoid exceeding maximal identifier length.
Addressing
rhn_content_source_ssl_mod_trig
*
ERROR at line 2:
ORA-00972: identifier is too long
diff --git a/schema/spacewalk/oracle/triggers/rhnContentSourceSsl.sql b/schema/spacewalk/oracle/triggers/rhnContentSourceSsl.sql
index 10376b0..6b0cd9b 100644
--- a/schema/spacewalk/oracle/triggers/rhnContentSourceSsl.sql
+++ b/schema/spacewalk/oracle/triggers/rhnContentSourceSsl.sql
@@ -14,7 +14,7 @@
--
create or replace trigger
-rhn_content_source_ssl_mod_trig
+rhn_cont_source_ssl_mod_trig
before insert or update on rhnContentSourceSsl
for each row
begin
diff --git a/schema/spacewalk/postgres/triggers/rhnContentSourceSsl.sql b/schema/spacewalk/postgres/triggers/rhnContentSourceSsl.sql
index 7ec289b..2df6026 100644
--- a/schema/spacewalk/postgres/triggers/rhnContentSourceSsl.sql
+++ b/schema/spacewalk/postgres/triggers/rhnContentSourceSsl.sql
@@ -1,6 +1,6 @@
--- oracle equivalent source sha1 2330953d139fc07f77743e6bc63abb49d0a2d147
+-- oracle equivalent source sha1 69c5d82c00ea96836eed1be6a65507f53b7730f3
-create or replace function rhn_content_source_ssl_mod_trig_fun() returns trigger as
+create or replace function rhn_cont_source_ssl_mod_trig_fun() returns trigger as
$$
begin
new.modified := current_timestamp;
@@ -10,7 +10,7 @@ $$ language plpgsql;
create trigger
-rhn_content_source_ssl_mod_trig
+rhn_cont_source_ssl_mod_trig
before insert or update on rhnContentSourceSsl
for each row
-execute procedure rhn_content_source_ssl_mod_trig_fun();
+execute procedure rhn_cont_source_ssl_mod_trig_fun();
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.oracle
index 10376b0..6b0cd9b 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.oracle
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.oracle
@@ -14,7 +14,7 @@
--
create or replace trigger
-rhn_content_source_ssl_mod_trig
+rhn_cont_source_ssl_mod_trig
before insert or update on rhnContentSourceSsl
for each row
begin
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.postgresql
index 7ec289b..2df6026 100644
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.postgresql
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/009-rhn_content_source_ssl_mod_trig.sql.postgresql
@@ -1,6 +1,6 @@
--- oracle equivalent source sha1 2330953d139fc07f77743e6bc63abb49d0a2d147
+-- oracle equivalent source sha1 69c5d82c00ea96836eed1be6a65507f53b7730f3
-create or replace function rhn_content_source_ssl_mod_trig_fun() returns trigger as
+create or replace function rhn_cont_source_ssl_mod_trig_fun() returns trigger as
$$
begin
new.modified := current_timestamp;
@@ -10,7 +10,7 @@ $$ language plpgsql;
create trigger
-rhn_content_source_ssl_mod_trig
+rhn_cont_source_ssl_mod_trig
before insert or update on rhnContentSourceSsl
for each row
-execute procedure rhn_content_source_ssl_mod_trig_fun();
+execute procedure rhn_cont_source_ssl_mod_trig_fun();