From 486444681a4543d9f61e11c2564b0bb392762d7f Mon Sep 17 00:00:00 2001
From: Dan Scott <dan@coffeecode.net>
Date: Mon, 9 Apr 2012 08:59:55 -0400
Subject: [PATCH] Bug 957453: Fix error in database seed data
The use of an explicit ID in creating a new
action_trigger.event_definition row was followed by the use of the
CURRVAL() function to grab the most recently issued value for
the action_trigger.event_defintion_id_seq sequence - which happened to
be 100, due to a previously issued SETVAL() on the sequence.
This resulted in references to non-existent event definitions and thus
an error in creating the stock database schema.
By using an explicit ID for the dependent row, we avoid this error.
Signed-off-by: Dan Scott <dan@coffeecode.net>
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
---
Open-ILS/src/sql/Pg/950.data.seed-values.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
index b4c6a26ba3..d53ae14db5 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -9289,7 +9289,7 @@ INSERT INTO action_trigger.environment (event_def, path) VALUES
(38, 'bib_rec.bib_record.simple_record');
INSERT INTO action_trigger.event_params (event_def, param, value)
- VALUES (currval('action_trigger.event_definition_id_seq'), 'check_email_notify', 1);
+ VALUES (38, 'check_email_notify', 1);
----------------------------------------------------------------
-- Seed data for queued record/item exports
--
2.11.0