[ZBX-4471] Warnings when applying dbpatches during 1.8 -> 2.0 upgrade Created: 2011 Dec 20 Updated: 2017 May 30 Resolved: 2011 Dec 23 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Installation (I) |
| Affects Version/s: | 2.0.0 |
| Fix Version/s: | 2.0.0rc4 |
| Type: | Incident report | Priority: | Major |
| Reporter: | dimir | Assignee: | dimir |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | database, dbpatches, upgrade | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Description |
|
This issue is about all the warnings that are issued when upgrading the database from 1.8 to 2.0 |
| Comments |
| Comment by dimir [ 2011 Dec 20 ] |
|
In 2.0 we will be supporting 8.1 and above so we can use proper escaping syntax in constant strings in dbpatches: http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-CONSTANTS |
| Comment by dimir [ 2011 Dec 20 ] |
|
Fixed in development branch svn://svn.zabbix.com/branches/dev/ZBX-4471 |
| Comment by Alexander Vladishev [ 2011 Dec 23 ] |
|
(1) PostgreSQL 8.1 does not support an "IF EXISTS" option. <dimir> Right, good catch. Added procedure to work this around. RESOLVED in r24243 |
| Comment by Alexander Vladishev [ 2012 May 09 ] |
|
Great work! Please review my changes in r27382:27398. |
| Comment by Alexander Vladishev [ 2012 May 09 ] |
|
(2) Don't forget to update documentation. http://www.zabbix.com/documentation/2.0/manual/installation/requirements#software (PostgreSQL req 8.0 -> 8.1) <dimir> RESOLVED |
| Comment by dimir [ 2012 May 10 ] |
|
Set "Fix Version/s". |
| Comment by dimir [ 2012 May 10 ] |
|
Fixed in pre-2.0.0 r27411. |