From 486444681a4543d9f61e11c2564b0bb392762d7f Mon Sep 17 00:00:00 2001 From: Dan Scott 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 Signed-off-by: Thomas Berezansky --- 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