Hi!
There is an Oracle-only operator for a set differences, called "MINUS"
and seems like it is already known problem when it comes to PostgreSQL.
It is seen in a several places, like hard-coded directly in Java code
com.redhat.rhn.manager.system.SystemManager as well as in
web/modules/rhn/RHN/DB/DataSource/xml/Package_queries.xml as
"snapshot_unservable_package_list" query.
Seems like there is no way to use PostgreSQL's "EXCEPT" along with
current query, so should we rewrite query in different way, like "NOT
IN" or and outer join?
--
Bo
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
