In fact, the query seems to be a bit too much restrictive.<div>I've downloaded a recent patch (not installed on my system) from oracle support and rhnpushed it.</div><div>When I go in the details of the patch, in the tab "target system" my client is listed.</div>
<div>But when I go in my system details, Software --> Patches --> Install, it is not listed.</div><div><br></div><div>Patch number: 121430</div><div><div>spaceschema=# select * from rhnServerOutdatedPackages where server_id = 1000010008;</div>
<div> server_id | package_name_id | package_evr_id | package_nvre | errata_id | errata_advisory</div><div>------------+-----------------+----------------+---------------------------+-----------+-----------------</div>
<div> 1000010008 | 7143 | 8682 | patch-solaris-121430-73-1 | |</div></div><div><br></div><div>The patch is listed as needed!</div><div><br></div><div>But the patch is not listed in the list of patches that can be installed on my system.</div>
<div><br></div><div>Pierre</div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2012/12/4 Pierre Casenove <span dir="ltr"><<a href="mailto:pcasenove@gmail.com" target="_blank">pcasenove@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I've modified as Jan suggested. <div>The query is now correctly executed.</div><div>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.</div>
<div>Exemple with patch 120412:</div><div><div>warning: The following requested patches have packages not installed on the system</div><div>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.</div>
</div><div><br></div><div>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.</div><div><br></div><div>
If the behaviour is as expected, you can commit.</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">2012/12/4 Jan Pazdziora <span dir="ltr"><<a href="mailto:jpazdziora@redhat.com" target="_blank">jpazdziora@redhat.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On Tue, Dec 04, 2012 at 04:21:18PM +0100, Pierre Casenove wrote:<br>
> hello,<br>
> I've patched rhn.jar... and now, I get an ISE:<br>
><br>
> Caused by: org.postgresql.util.PSQLException: ERROR: column reference<br>
> "name" is ambiguous<br>
> I'm on RHEL 5 with pgsql 8.4.<br>
<br>
</div>Could you change that<br>
<br>
order by upper(name || '-' || evr_t_as_vre_simple(full_list.evr))<br>
<br>
in the patch to<br>
<br>
order by upper(<a href="http://pn.name" target="_blank">pn.name</a> || '-' || evr_t_as_vre_simple(full_list.evr))<br>
<br>
? (Not tested, just looking at the code.)<br>
<span><font color="#888888"><br>
--<br>
Jan Pazdziora<br>
Principal Software Engineer, Satellite Engineering, Red Hat<br>
</font></span><div><div><br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>