]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#845096 - coded_value_map_id_seq doesn't have a proper last_value
authorMichael Peters <mrpeters@library.in.gov>
Tue, 10 Apr 2012 20:12:13 +0000 (16:12 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Mon, 11 Jun 2012 15:59:38 +0000 (11:59 -0400)
commit37aa19848f43d2a9210265d88c93f2650fcdf65f
tree2d0e99b1621f956a6d81d55ab1c4620a100dc7af
parentb5c968d59c24baadaf0bf63982c7767d689ac725
LP#845096 - coded_value_map_id_seq doesn't have a proper last_value

Thanks to Kathy Lussier for the original report.  Kathy discovered
that users were unable to add new Coded Value Maps via the staff client.

With some log digging, I discovered the culprit was a rash of
primary key errors.

With help from Dan Scott, I was able to rectify this via a quick bit
of SQL which properly sets the last_value in the sequence.

Thanks, Kathy and Dan!

Signed-off-by: Michael Peters <mrpeters@library.in.gov>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/0716.coded_value_map_id_seq_fix.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql