Hi All, The object EVR_T has been ported to Postgres, and resides in schema/spacewalk/postgres/class/evr_t.sql
Porting the object involved .) Creating a TYPE evr_t. .) Creating overloaded operators to compare two evr_t objects; these will enable the ORDER BY to work on these objects. .) Creating an operator class so that evr_t based columns can be indexed using BTree. .) Additionally, the two member functions as_vre() and as_ver_simple() have been converted to global functions that accept a single EVR_T object. The only place in the whole source where an EVR_T is being instantiated is in DB function lookup_evr(). So porting just that autonomous function will suffice. In couple of places in perl an empty evr_t object is instantiated as EVR_T( null, 0, 0 ) (see below). For these queries to work with Postgres such instantiations will have to be changed to (null, 0, 0 )::EVR_T. Hopefully, some trickery can be employed in perl at these few places to get this to work. ./web/modules/rhn/RHN/DB/Scheduler.pm: AND SP.evr_id = PE.id), ${rhn_class}EVR_T(NULL, 0, 0)) Best regards, -- gurjeet[.sin...@enterprisedb.com EnterpriseDB http://www.enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com
_______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel