]> git.evergreen-ils.org Git - Evergreen.git/commit
Bug 957453: Fix error in database seed data
authorDan Scott <dan@coffeecode.net>
Mon, 9 Apr 2012 12:59:55 +0000 (08:59 -0400)
committerThomas Berezansky <tsbere@mvlc.org>
Mon, 9 Apr 2012 13:23:55 +0000 (09:23 -0400)
commit486444681a4543d9f61e11c2564b0bb392762d7f
tree022a1daed87628fcbb953cafba9444ce81f04e18
parent1f349b5529aae0687aa6dece8088a73f5f442f2e
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