-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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?

You can see quite a few other queries in the file, I don't know how
many of them are going to end up getting called but this is the first
one I hit.

Thoughts?

Thanks,

Devan

- -- 
  Devan Goodwin <dgood...@redhat.com>
  Software Engineer     Spacewalk / RHN Satellite
  Halifax, Canada       650.567.9039x79267
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)

iEYEARECAAYFAkmHni0ACgkQAyHWaPV9my6UAACeJQlpd/p5CPHCN0oq/31DX/TI
JPUAnRuHFy6c0Gr8xSUNcOF+SHf2uMVc
=82ZA
-----END PGP SIGNATURE-----

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to