Open-ILS/src/sql/Pg/upgrade/0416.schema.rename-recuring-idx.sql

   1 INSERT INTO config.upgrade_log (version) VALUES ('0416'); -- Scott McKellar
   2
   3 \qecho No transaction.  Renaming two indexes to correct spelling.
   4 \qecho If either change fails, then the index was probably created
   5 \qecho correctly in the first place; ignore the failure.
   6
   7 ALTER INDEX config.rule_recuring_fine_name_key
   8         RENAME TO rule_recurring_fine_name_key;
   9
  10 ALTER INDEX config.rule_recuring_fine_pkey
  11         RENAME TO rule_recurring_fine_pkey;