Re: [Spacewalk-devel] What to do with an Oracle-only set-difference operator "MINUS"?
On Fri, May 06, 2011 at 04:38:10PM +0200, Bo Maryniuk wrote: > > 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? Yes, that's what we recommend in the porting guide: https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide#MINUSkeyword Yours, -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
Re: [Spacewalk-devel] What to do with an Oracle-only set-difference operator "MINUS"?
Bo Maryniuk wrote: % 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? https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide#MINUSkeyword Regards, -- Michael Mráka Satellite Engineering, Red Hat ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
[Spacewalk-devel] What to do with an Oracle-only set-difference operator "MINUS"?
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
