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

    • Incident report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.1
    • 2.1.8
    • Installation (I)
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: