From aacf49e00625e2ca75279e8b721167ee7697dd26 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 20 May 2019 14:44:45 -0400 Subject: [PATCH] removing looking for usrname collections only on non-deleted records since constraint is on all usrnames --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index f9fe57e..2607c95 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -5291,7 +5291,7 @@ BEGIN RAISE INFO '% incumbent barcode collisions', incumbent_barcode_collision_count; FOR x_barcode IN - SELECT a.usrname FROM actor.usr a, actor_usr_legacy b WHERE x_migrate AND a.deleted IS FALSE AND a.usrname = b.usrname + SELECT a.usrname FROM actor.usr a, actor_usr_legacy b WHERE x_migrate AND a.usrname = b.usrname LOOP FOR x_id IN SELECT DISTINCT id FROM actor_usr_legacy WHERE x_migrate AND usrname = x_barcode LOOP -- 1.7.2.5