Uploaded image for project: 'Image Archives'
  1. Image Archives
  2. IMG-43

totoro's reindex_release_via_catno is completely wrong

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • None
    • None

      We have one that reads thus:

      DECLARE
          release_mbid UUID;
      BEGIN
          SELECT gid INTO release_mbid
            FROM musicbrainz.release
            JOIN musicbrainz.release_label ON release_label.release = release.id
            WHERE release = NEW.id;
          IF FOUND THEN
            PERFORM pgq.insert_event('CoverArtIndex', 'index', release_mbid::text);
          END IF;
          RETURN NULL;
      END;
      

      which means that we update whatever release shares an id with an updated release_label row.

            ianmcorvidae Ian McEwen
            ianmcorvidae Ian McEwen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package