LP#845096 - coded_value_map_id_seq doesn't have a proper last_value collab/dyrcona/coded_value_map_id_seq_fix
authorMichael Peters <mrpeters@library.in.gov>
Tue, 10 Apr 2012 20:12:13 +0000 (16:12 -0400)
committerJason Stephenson <jstephenson@mvlc.org>
Wed, 11 Apr 2012 19:02:54 +0000 (15:02 -0400)
commit38bb030a25660a9474101809f91b78bc7a386831
tree2a1ec59331118e290cd29986f95a0e772f824565
parent17b8f4abb1d922522ffadc440f4b6e3660718874
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>
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.coded_value_map_id_seq_fix.sql [new file with mode: 0644]