From b0286eace4050266e6aa5f659bfaedc5218c7bdf Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 3 Mar 2011 15:48:31 +0000 Subject: [PATCH] Patch (mildly revised) from Anoop Atre to address new Postgres 9.0 strictness requirements involving plan invalidation git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@19569 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql index 4946c28b3a..6c911f65c0 100644 --- a/Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql @@ -3,7 +3,8 @@ BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('2.0.1'); INSERT INTO config.upgrade_log (version) VALUES ('0480'); -CREATE OR REPLACE FUNCTION actor.usr_purge_data( +DROP FUNCTION IF EXISTS actor.usr_purge_data(INT, INT); +CREATE FUNCTION actor.usr_purge_data( src_usr IN INTEGER, specified_dest_usr IN INTEGER ) RETURNS VOID AS $$ -- 2.11.0