Description of problem: We have temporary table rhnPaidErrataTempCache in our schema. It seems to be used by java/code/src/com/redhat/rhn/taskomatic/task/ErrataMailer.java to store some data which are immediatelly processed and then removed from this table. We need the logic rewritten in such a way that the data which gets stored in that temporary table are selected in correct order and processed on the fly, for each user and each server. We want to get rid of that temporary table because the semantics of temporary tables is different in PostgreSQL, and besides, it can be done better some different way anyway. Version-Release number of selected component (if applicable): Spacewalk nightly (1.2). How reproducible: Look at code. Steps to Reproduce: 1. Check errata mailer operation. Actual results: For the errata mailer to work, the temporary table rhnPaidErrataTempCache is needed. Expected results: Errata mailer should keep on working even after refactoring, when temporary table rhnPaidErrataTempCache is removed. Additional info:
Table removed. spacewalk.git: 8015ae73ed6bb341407ecf9edd015a874ae2fa6e
adding upgrade script for delete_errata procedure spacewalk.git: 8230ee7cdd4449b1437825fe6a54b7f4ba2de1f3
Moving ON_QA. Please use the Spacewalk 1.2 release candidate yum repo at http://koji.spacewalkproject.org/spacewalk/split/spacewalk-5E/server/spacewalk-5E-1.2/$basearch/os http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f12/server/spacewalk-f12-1.2/$basearch/os http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f13/server/spacewalk-f13-1.2/$basearch/os http://koji.spacewalkproject.org/spacewalk/split/spacewalk-f14/server/spacewalk-f14-1.2/$basearch/os (depending on your OS) to verify the bugzilla.
With Spacewalk 1.2 released, marking as CLOSED CURRENTRELEASE. https://www.redhat.com/archives/spacewalk-list/2010-November/msg00111.html