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@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@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();
spacewalk-commits@lists.fedorahosted.org