[ZBX-416] Proposal patch: Fix problem of implicit cast with PostgreSQL 8.3 Created: 2008 Aug 05 Updated: 2017 May 30 Resolved: 2011 Jan 19 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 1.4.5 |
Fix Version/s: | 1.8.5 |
Type: | Incident report | Priority: | Major |
Reporter: | Fernando Ike de Oliveira | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 2 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: | nodewatcher_fike.patch zabbix-1.8.3-alt-ZBX-416.patch | ||||||||||||
Issue Links: |
|
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, |
Comments |
Comment by Aleksey Avdeev [ 2010 Aug 11 ] |
I finalized this patch for zabbix-1.8.3. The result in brunch ALT/zabbix/1.8.3/ 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. |
Comment by Aleksey Avdeev [ 2010 Aug 11 ] |
The output of git diff ALT/zabbix/1.8.3/ |
Comment by Alexander Vladishev [ 2011 Jan 18 ] |
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-416 |
Comment by Alexei Vladishev [ 2011 Jan 19 ] |
Fixed in version pre1.8.5, r17036. |