java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
New commits:
commit c56940f907dfde312181da56d0345d641a3ce06d
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Thu Sep 23 18:12:09 2010 -0400
636442 - fixing issue where calling packages.removePackage() api call could result in
a unique constraint exception
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
index b502c6a..2d5006e 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Package_queries.xml
@@ -1431,7 +1431,8 @@ SELECT P.id, PE.epoch, PE.version, PE.release
<write-mode name="schedule_pkg_for_delete">
<query params="path">
INSERT INTO rhnPackageFileDeleteQueue
- VALUES (:path, sysdate)
+ (select :path ,sysdate from dual where not exists
+ (select path from rhnPackageFileDeleteQueue where path = :path))
</query>
</write-mode>
Show replies by date