Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-21854

Ensure Gen3 Registry symbols don't exceed DB-imposed name length limits

    Details

      Description

      Both PostgreSQL and Oracle put limits on the lengths of database names that we've run into at one point or another, and while so far that's been limited to the names of things whose names don't matter much (e.g. foreign key constraints), future functionality that depends on dynamic table creation will make it more likely for this to extend to more visible names.

      We should adopt a scheme for truncating database names while retaining uniqueness (e.g. "replace any characters after the Nth with a length-M hash of them"), and apply it to all symbols.  This should not affect the names used in any Python code.

        Attachments

          Issue Links

            Activity

            Hide
            jbosch Jim Bosch added a comment -

            This was implemented on DM-22609.

            Show
            jbosch Jim Bosch added a comment - This was implemented on DM-22609 .

              People

              • Assignee:
                jbosch Jim Bosch
                Reporter:
                jbosch Jim Bosch
                Watchers:
                Jim Bosch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Summary Panel