rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/postgres/triggers/rhnConfigRevision.sql | 6 +++---
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
3 files changed, 8 insertions(+), 5 deletions(-)
New commits:
commit c7f01aaddbe5ec8e4f776dcc8c193aa61e2f3bd9
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon Jun 24 13:39:37 2013 +0200
Automatic commit of package [spacewalk-schema] release [1.10.49-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index a1a0389..090d811 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.48-1 schema/spacewalk/
+1.10.49-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec
b/schema/spacewalk/spacewalk-schema.spec
index 66522df..5f94d21 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.48
+Version: 1.10.49
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Mon Jun 24 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.49-1
+- fixed syntax error in rhn_confrevision_del_trig_fun
+
* Fri Jun 21 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.48-1
- 906157 - upgrade scripts for rhn_config.delete_file() and
rhn_confrevision_ccid_idx index
commit 9e79f808d1d1be673097d516de7aeff7b1be251d
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon Jun 24 13:33:36 2013 +0200
fixed syntax error in rhn_confrevision_del_trig_fun
diff --git a/schema/spacewalk/postgres/triggers/rhnConfigRevision.sql
b/schema/spacewalk/postgres/triggers/rhnConfigRevision.sql
index aeb59cb..503a74c 100644
--- a/schema/spacewalk/postgres/triggers/rhnConfigRevision.sql
+++ b/schema/spacewalk/postgres/triggers/rhnConfigRevision.sql
@@ -43,12 +43,12 @@ begin
set invalid = cr_removed
where id in (select snapshot_id
from rhnSnapshotConfigRevision
- where config_revision_id = :old.id);
+ where config_revision_id = old.id);
delete from rhnSnapshotConfigRevision
- where config_revision_id = old.id;
+ where config_revision_id = old.id
and snapshot_id in (select snapshot_id
from rhnSnapshotConfigRevision
- where config_revision_id = :old.id);
+ where config_revision_id = old.id);
return old;
end;
$$ language plpgsql;
Show replies by date