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
