LP#845096 - coded_value_map_id_seq doesn't have a proper last_value user/mrpeters-isl/coded_value_map_id_seq_fix
authorMichael Peters <mrpeters@library.in.gov>
Tue, 10 Apr 2012 20:12:13 +0000 (16:12 -0400)
committerMichael Peters <mrpeters@library.in.gov>
Tue, 10 Apr 2012 20:16:18 +0000 (16:16 -0400)
commit5e7792c88882740802de832adf14bc6af19f8ff5
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>
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]