branch master updated: Fix more of rebuilding one of the tables

[Christopher Baines]

This is an automated email from the git hooks/post-receive script.

cbaines pushed a commit to branch master
in repository data-service.

The following commit(s) were added to refs/heads/master by this push:
     new 40035bc  Fix more of rebuilding one of the tables
40035bc is described below

commit 40035bcf9a3bfb260b44c56cea914ec5c7e438b0
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Mon May 23 21:18:59 2022 +0100

    Fix more of rebuilding one of the tables
---
 guix-data-service/model/package-derivation-by-guix-revision-range.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/guix-data-service/model/package-derivation-by-guix-revision-range.scm 
b/guix-data-service/model/package-derivation-by-guix-revision-range.scm
index 585c2e3..15c2fa7 100644
--- a/guix-data-service/model/package-derivation-by-guix-revision-range.scm
+++ b/guix-data-service/model/package-derivation-by-guix-revision-range.scm
@@ -54,7 +54,7 @@ WHERE git_repository_id = $1 AND
     "
 INSERT INTO package_derivations_by_guix_revision_range
 SELECT DISTINCT
-       $1,
+       $2,
        packages.name AS package_name,
        packages.version AS package_version,
        revision_packages.derivation_id AS derivation_id,
@@ -101,7 +101,7 @@ ORDER BY packages.name, packages.version")
      conn
      (string-append
       "
-CREATE TABLE package_derivations_by_guix_revision_range_git_branch_"
+CREATE TABLE IF NOT EXISTS 
package_derivations_by_guix_revision_range_git_branch_"
       (number->string git-branch-id) "
 PARTITION OF package_derivations_by_guix_revision_range FOR VALUES IN ("
       (number->string git-branch-id)