From 310a575c1834fa515b7ef82d9f99b0836a40f8b4 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 5 Oct 2018 15:22:58 -0400 Subject: [PATCH] handle ambiguity Signed-off-by: Jason Etheridge --- 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 1e51df1..df07714 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -3237,7 +3237,7 @@ CREATE OR REPLACE FUNCTION migration_tools.handle_profile (TEXT,TEXT) RETURNS VO || ' ADD COLUMN x_profile INTEGER'; EXECUTE 'UPDATE ' || quote_ident(table_name) || ' a' - || ' SET x_profile = id FROM permission.grp_tree b' + || ' SET x_profile = b.id FROM permission.grp_tree b' || ' WHERE BTRIM(UPPER(a.desired_profile)) = BTRIM(UPPER(b.name))'; EXECUTE 'SELECT migration_tools.assert( -- 1.7.2.5