ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-416

Proposal patch: Fix problem of implicit cast with PostgreSQL 8.3

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.5
    • Fix Version/s: 1.8.5
    • Component/s: Server (S)
    • Labels:
      None

      Description

      This is problem occurs with PostgreSQL 8.3 or major. The 8.3 remove much types implicit cast, the recommendation PGDG (PostgreSQL Development Group) is to use explicit cast to sql expression SQL. This patch add explicit cast to sql expression with UNION in "nodewatcher.c".

      Regards,

      1. nodewatcher_fike.patch
        1 kB
        Fernando Ike de Oliveira
      2. zabbix-1.8.3-alt-ZBX-416.patch
        2 kB
        Aleksey Avdeev

        Issue Links

          Activity

          Hide
          Aleksey Avdeev added a comment -

          I finalized this patch for zabbix-1.8.3. The result in brunch ALT/zabbix/1.8.3/ZBX-416 in my git repository (see http://git.altlinux.org/people/solo/packages/zabbix.git?p=zabbix.git;a=shortlog;h=refs/heads/ALT/zabbix/1.8.3/ZBX-416).

          zabbix-1.8.3-alt0.rc3.svn.13816.1 (see http://git.altlinux.org/people/solo/packages/zabbix.git?p=zabbix.git;a=commit;h=d218d67b4a8b913dadbae2cac21b36e72734f4fd) posted Sisyphus (see http://en.altlinux.org/Sisyphus) and successfully interact with PostgreSQL 8.4 using distributed monitoring.

          Show
          Aleksey Avdeev added a comment - I finalized this patch for zabbix-1.8.3. The result in brunch ALT/zabbix/1.8.3/ ZBX-416 in my git repository (see http://git.altlinux.org/people/solo/packages/zabbix.git?p=zabbix.git;a=shortlog;h=refs/heads/ALT/zabbix/1.8.3/ZBX-416 ). zabbix-1.8.3-alt0.rc3.svn.13816.1 (see http://git.altlinux.org/people/solo/packages/zabbix.git?p=zabbix.git;a=commit;h=d218d67b4a8b913dadbae2cac21b36e72734f4fd ) posted Sisyphus (see http://en.altlinux.org/Sisyphus ) and successfully interact with PostgreSQL 8.4 using distributed monitoring.
          Hide
          Aleksey Avdeev added a comment -

          The output of git diff ALT/zabbix/1.8.3/ZBX-416{^^,}

          Show
          Aleksey Avdeev added a comment - The output of git diff ALT/zabbix/1.8.3/ ZBX-416 {^^,}
          Hide
          Alexander Vladishev added a comment -

          Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-416

          Show
          Alexander Vladishev added a comment - Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-416
          Hide
          Alexei Vladishev added a comment -

          Fixed in version pre1.8.5, r17036.

          Show
          Alexei Vladishev added a comment - Fixed in version pre1.8.5, r17036.

            People

            • Assignee:
              Unassigned
              Reporter:
              Fernando Ike de Oliveira
            • Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: