Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023040Openbravo ERPA. Platformpublic2013-02-12 09:422013-04-26 12:52
Reportermarvintm 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023040: Warning in PostgreSQL 9.2 related to a statement in the prescript
DescriptionWhen the prescript it's executed (for example in update.database), there is currently a warning in PostgreSQL 9.2:


WARNING: GLOBAL is deprecated in temporary table creation at character 8

Steps To ReproduceJust run update.database in PostgreSQL 9.2
Proposed SolutionProbably the "global" in the prescript commands can just be removed.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00247693.0MP28 closed shuehner More deprecation warnings related to temp-table creation on postgresql >=9.3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-12 09:42marvintmNew Issue
2013-02-12 09:42marvintmAssigned To => marvintm
2013-02-12 09:42marvintmModules => Core
2013-02-12 09:42marvintmOBNetwork customer => No
2013-02-12 09:42marvintmTriggers an Emergency Pack => No
2013-04-15 16:43AugustoMauchAssigned Tomarvintm => AugustoMauch
2013-04-15 16:45AugustoMauchIssue Monitored: marvintm
2013-04-15 16:49AugustoMauchReview Assigned To => marvintm
2013-04-15 16:49AugustoMauchNote Added: 0057910
2013-04-15 16:50AugustoMauchNote Edited: 0057910bug_revision_view_page.php?bugnote_id=0057910#r4581
2013-04-15 16:50AugustoMauchNote Deleted: 0057910
2013-04-15 16:57hgbotCheckin
2013-04-15 16:57hgbotNote Added: 0057911
2013-04-15 16:57hgbotStatusnew => resolved
2013-04-15 16:57hgbotResolutionopen => fixed
2013-04-15 16:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc93df75113ffc1f4e93899f95c00ab7f2b4a3db [^]
2013-04-16 19:18hudsonbotCheckin
2013-04-16 19:18hudsonbotNote Added: 0057981
2013-04-26 12:52marvintmStatusresolved => closed
2013-09-14 08:53shuehnerRelationship addedrelated to 0024769

Notes
(0057911)
hgbot   
2013-04-15 16:57   
Repository: erp/devel/pi
Changeset: cc93df75113ffc1f4e93899f95c00ab7f2b4a3db
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Apr 15 16:53:17 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cc93df75113ffc1f4e93899f95c00ab7f2b4a3db [^]

Fixes issue 23040: Removed 'GLOBAL' from postgresql prescript.

As stated here [1] the use of GLOBAL has been deprecated in postgresql.

[1] http://www.postgresql.org/message-id/E1SevQr-0001Mb-12@gemulon.postgresql.org [^]

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0057981)
hudsonbot   
2013-04-16 19:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8df08bea850d [^]

Maturity status: Test