On Mon, Feb 02, 2009 at 09:30:17PM -0400, Devan Goodwin wrote:
>
> Hey guys, blocked on another spot in the installer and wanted to queue
> these items up for porting:
>
> Out of backend/satellite_tools/satCerts.py:
>
> _query_latest_version = rhnSQL.Statement("""
> SELECT nvl(version, 0) version, version orig_version, cert,
> TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued,
> TO_CHAR(expires, 'YYYY-MM-DD HH24:MI:SS') expires
> FROM rhnSatelliteCert
> WHERE label = :label
> ORDER BY version DESC NULLS LAST
> """)
>
> So rhnSatelliteCert needs some mappings, I think the TO_CHAR looks
> usable in PostgreSQL, is it just the nvl that needs to change here?
It looks like nvl is in Orafce.
--
Jan Pazdziora | adelton at #satellite*, #brno
Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
