exclude etch from valid package releases

git-svn-id: svn+ssh://svn.debian.org/svn/secure-testing@16216 e39458fd-73e7-0310-bf30-c45bca0a0e42

1 files changed, 2 insertions, 0 deletions

diff --git a/lib/python/security_db.py b/lib/python/security_db.py
index 93808ccb7d..efeec4eb9d 100644
--- a/lib/python/security_db.py
+++ b/lib/python/security_db.py
@@ -1579,6 +1579,7 @@ class DB:
             """SELECT string_list(release) AS releases, version
             FROM (SELECT release, version FROM source_packages
             WHERE name = ?
+            AND release IN ('lenny', 'squeeze', 'wheezy', 'sid', 'experimental') 
             ORDER BY release_to_number(release))
             GROUP BY version""", (pkg,)):
             yield releases.split(', '), version
@@ -1633,6 +1634,7 @@ class DB:
             p.version AS version, s.vulnerable AS vulnerable
             FROM source_package_status AS s, source_packages AS p
             WHERE s.bug_name = ? AND p.rowid = s.package
+            AND release in ('lenny', 'squeeze', 'wheezy', 'sid', 'experimental')
             ORDER BY release_to_number(p.release), p.subrelease)
             GROUP BY package, version, vulnerable
             ORDER BY package, version COLLATE version""",