Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-5374

postgresql dbpatch does not work when partitioning is in use

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.1.8
    • Component/s: Installation (I)
    • Environment:
      Linux / Postgresql 9.1

      Description

      The db upgrade patch does not work when partitionning is used (via child tables)

      The script explicitly do not upgrade Child tables because of "ONLY" directive

      ALTER TABLE ONLY history_uint
      ALTER itemid DROP DEFAULT,
      ADD ns integer DEFAULT '0' NOT NULL;

      postgresql doc
      "If a table has any descendant tables, it is not permitted to add, rename, or change the type of a column in the parent table without doing the same to the descendants. That is, ALTER TABLE ONLY will be rejected. This ensures that the descendants always have columns matching the parent."

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dakol dakol
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: