<html> <head> <style></style> </head> <body class='hmmessage'><div dir='ltr'> Hello<BR>I found this page after my post... I'm searching the equivalent query using left outer join statement... but I'm not an SQL expert!<BR>I've already found the query.xml file to modify!<BR>Once I find the statement, I'll post the patch.<br> <BR><div>> Date: Fri, 22 Jul 2011 19:44:02 +0200<br>> From: msuchy@redhat.com<br>> To: spacewalk-list@redhat.com<br>> Subject: Re: [Spacewalk-list] Error 500 on snapshots pages<br>> <br>> On 07/22/2011 08:15 AM, Pierre Casenove wrote:<br>> > Here is the SQL statement executed:<br>> > ERROR: syntax error at or near "MINUS" at character 869<br>> <br>> https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide#MINUSkeyword<br>> <br>> Patches are welcome.<br>> <br>> -- <br>> Miroslav Suchı<br>> Red Hat Satellite Engineering<br>> <br>> _______________________________________________<br>> Spacewalk-list mailing list<br>> Spacewalk-list@redhat.com<br>> https://www.redhat.com/mailman/listinfo/spacewalk-list<br></div> </div></body> </html>