Hello, I made some more progress, instead of using only id for my query:
> rhnschema=# select * from rhnPackage where id = 361804; > 361804 | 1 | 3599 | 73216 | 119 | 14 | > 4.4.2.3 | PAM (Pluggable > Authentication Modules) is a system security tool that+| A Security Tool that > Provides Authenticati > on for Applications | 177907 | 624540 | 616636 | sheep24 > | 2016-06-16 11:57:4 > 4 | 96742 | 12360858 | SUSE LINUX Products GmbH, Nuernberg, > Germany | cpio | > 0 | > redhat/1/9f9/pam-32bit/1.1.5-0.17.2/x86_64/9f97a66c3d64f005af572d7de04ac161/pam-32bit-1.1.5-0 > .17.2.x86_64.rpm | | BSD 3-Clause; GPL v2 or later | | > 2016-06-23 21:07:24+02 | 20 > 16-06-23 21:07:24.494433+02 | 2016-06-23 21:07:24.494433+02 | 616 | > 16376 > (1 row) I used the "full query": rhnschema=# select * from rhnPackage where org_id = 1 and name_id = 2135 and evr_id = 73214 and package_arch_id = 119 and checksum_id = 12360895; And got 0 rows. I found out that the evr_id is off by 2 in this case, and off by 1 in some other cases. Now the big question is: What is the use case of evr_id in table rhnPackage and how can I repair my entries? Regards, Bernhard
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list