When upgrading your plug-ins, note the following:
- The versions of the data type plug-in and the index type plug-in must match.
- When upgrading both data type and index type plug-ins, be sure to upgrade the data type plug-in first.
- Once you register a new version of a plug-in, you can no longer restore the old version.
- The SPECIFIC_NAME column is updated in the SQL_PLUGIN_ROUTINES and SQL_PLUGIN_ROUTINE_PARAMS data dictionary tables.
- If you change the owner of a plug-in during upgrading, the functions may become invalid. In such cases, re-create the function's SQL object using ALTER ROUTINE.