I've modified as Jan suggested. The query is now correctly executed. And the query is much better: I get a list of 39 patches only, but when I take a closer look, these patches are not applicable to my ystem, as the package it patches is not installed. Exemple with patch 120412: warning: The following requested patches have packages not installed on the system warning: Package SUNWcleu2 from directory SUNWcleu2 in patch 120412-11 is not installed on the system. Changes for package SUNWcleu2 will not be applied to the system.
I'm not sure if spacewalk is able to detect that, even more because I actually didn't rhnpushed all the Solaris packages to spacewalk server, but only the patches. If the behaviour is as expected, you can commit. 2012/12/4 Jan Pazdziora <[email protected]> > On Tue, Dec 04, 2012 at 04:21:18PM +0100, Pierre Casenove wrote: > > hello, > > I've patched rhn.jar... and now, I get an ISE: > > > > Caused by: org.postgresql.util.PSQLException: ERROR: column reference > > "name" is ambiguous > > I'm on RHEL 5 with pgsql 8.4. > > Could you change that > > order by upper(name || '-' || evr_t_as_vre_simple(full_list.evr)) > > in the patch to > > order by upper(pn.name || '-' || > evr_t_as_vre_simple(full_list.evr)) > > ? (Not tested, just looking at the code.) > > -- > Jan Pazdziora > Principal Software Engineer, Satellite Engineering, Red Hat > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
