Stop using package_versions_by_guix_revision_range

It's been replaced by the package_derivations_by_guix_revision_range table.

1 files changed, 0 insertions, 12 deletions

diff --git a/scripts/guix-data-service-create-small-backup b/scripts/guix-data-service-create-small-backup
index 6616c52..e5f5774 100755
--- a/scripts/guix-data-service-create-small-backup
+++ b/scripts/guix-data-service-create-small-backup
@@ -180,18 +180,6 @@ WITH guix_revision_ids AS (
     SELECT commit FROM git_branches
   )
 )
-DELETE FROM package_versions_by_guix_revision_range
-WHERE first_guix_revision_id NOT IN (SELECT id FROM guix_revision_ids) OR
-      last_guix_revision_id NOT IN (SELECT id FROM guix_revision_ids);
-EOF
-
-psql -v ON_ERROR_STOP=1 --echo-queries --no-psqlrc "$URI_FOR_DATABASE" -U guix_data_service <<EOF &
-
-WITH guix_revision_ids AS (
-  SELECT id FROM guix_revisions WHERE commit IN (
-    SELECT commit FROM git_branches
-  )
-)
 DELETE FROM package_derivations_by_guix_revision_range
 WHERE first_guix_revision_id NOT IN (SELECT id FROM guix_revision_ids) OR
       last_guix_revision_id NOT IN (SELECT id FROM guix_revision_ids);