pkgdb.c - patch

gistfile1.diff

# git diff
diff --git a/libpkg/pkgdb.c b/libpkg/pkgdb.c
index 93484e1..84df484 100644
--- a/libpkg/pkgdb.c
+++ b/libpkg/pkgdb.c
@@ -703,7 +703,9 @@ pkgdb_query_remote(struct pkgdb *db, const char *pattern)
                        "arch, osversion, maintainer, www, pkgsize, "
                        "flatsize AS newflatsize, cksum, path AS repopath "
                "FROM remote.packages "
-               "WHERE origin = ?1";
+               "WHERE origin = ?1 " 
+               "AND NOT EXISTS (SELECT 1 FROM main.packages AS p "
+               "WHERE p.origin = ?1) ";
        char sql_deps[] = ""
                "SELECT d.name, d.origin, d.version "
                "FROM remote.deps AS d "