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
