From 7e19807a3f2dd53323e1fe75541279212ff3213e Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 20 Aug 2009 15:34:25 +0000 Subject: [PATCH] thinko in recent ingest fix git-svn-id: svn://svn.open-ils.org/ILS/trunk@13897 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/reporter-schema.sql | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/reporter-schema.sql b/Open-ILS/src/sql/Pg/reporter-schema.sql index e79f592580..da466129ab 100644 --- a/Open-ILS/src/sql/Pg/reporter-schema.sql +++ b/Open-ILS/src/sql/Pg/reporter-schema.sql @@ -175,14 +175,12 @@ ALTER TABLE reporter.materialized_simple_record ADD PRIMARY KEY (id); CREATE VIEW reporter.super_simple_record AS SELECT * FROM reporter.materialized_simple_record; CREATE OR REPLACE FUNCTION reporter.simple_rec_update (r_id BIGINT, deleted BOOL) RETURNS BOOL AS $$ -DECLARE - new_data RECORD; BEGIN DELETE FROM reporter.materialized_simple_record WHERE id = r_id; IF NOT deleted THEN - INSERT INTO reporter.materialized_simple_record SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record WHERE id = NEW.record; + INSERT INTO reporter.materialized_simple_record SELECT DISTINCT ON (id) * FROM reporter.old_super_simple_record WHERE id = r_id; END IF; RETURN TRUE; -- 2.43.2