From 420372c786b2c1a31aaf2f943aa7538b48c6dd49 Mon Sep 17 00:00:00 2001 From: erickson Date: Thu, 4 Jun 2009 22:26:01 +0000 Subject: [PATCH] clear pending flag on an approved address git-svn-id: svn://svn.open-ils.org/ILS/trunk@13321 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/999.functions.global.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 4fb5094e12..21cd2dc060 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -198,7 +198,7 @@ BEGIN -- address replaces an existing address DELETE FROM actor.usr_address WHERE id = -old_id; UPDATE actor.usr_address SET id = -id WHERE id = old_id; - UPDATE actor.usr_address SET replaces = NULL, id = old_id WHERE id = pending_id; + UPDATE actor.usr_address SET replaces = NULL, id = old_id, pending = 'f' WHERE id = pending_id; RETURN old_id; END $$ LANGUAGE plpgsql; -- 2.43.2