Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023040
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2013-02-12 09:422013-04-26 12:52
ReportermarvintmView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncc93df75113f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023040: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00247693.0MP28 closedshuehner More deprecation warnings related to temp-table creation on postgresql >=9.3 

-  Notes
(0057911)
hgbot (developer)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2013-02-12 09:42 marvintm New Issue
2013-02-12 09:42 marvintm Assigned To => marvintm
2013-02-12 09:42 marvintm Modules => Core
2013-02-12 09:42 marvintm Triggers an Emergency Pack => No
2013-04-15 16:43 AugustoMauch Assigned To marvintm => AugustoMauch
2013-04-15 16:45 AugustoMauch Issue Monitored: marvintm
2013-04-15 16:49 AugustoMauch Review Assigned To => marvintm
2013-04-15 16:49 AugustoMauch Note Added: 0057910
2013-04-15 16:50 AugustoMauch Note Edited: 0057910 View Revisions
2013-04-15 16:50 AugustoMauch Note Deleted: 0057910
2013-04-15 16:57 hgbot Checkin
2013-04-15 16:57 hgbot Note Added: 0057911
2013-04-15 16:57 hgbot Status new => resolved
2013-04-15 16:57 hgbot Resolution open => fixed
2013-04-15 16:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cc93df75113ffc1f4e93899f95c00ab7f2b4a3db [^]
2013-04-16 19:18 hudsonbot Checkin
2013-04-16 19:18 hudsonbot Note Added: 0057981
2013-04-26 12:52 marvintm Status resolved => closed
2013-09-14 08:53 shuehner Relationship added related to 0024769


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker