Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-7366

Convert most or all 'varchar' DB fields to type 'text'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 14.0.3
    • Fix Version/s: Backlog
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None

      Description

      To avoid SQL exceptions when an unexpectedly long string value is stored in the database, we should convert almost all varchar fields in the database over to PostgreSQL type 'text'. PostgreSQL handles all string values the same internally so there is no optimization benefit to using varchar over text.

      Use of varchar has caused several other bugs so we need to start using text everywhere that it makes sense to avoid problems like this in the future.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                seth Seth Leger
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: