Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002712Openbravo ERPA. Platformpublic2008-03-13 21:152010-01-21 18:45
Reporterjaimetorre 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002712: ant install.source tries to delete role under postgresql
DescriptionWhen building Openbravo from sources under PostgreSQL, the ant task 'install.sources' tries to delete the role chosen in the configuration if it already exists (and fails if it owns any object).

It does make sense under Oracle not to allow to install Openbravo with an existing database user, as Oracle unifies the concept of context/database with the concept of user.

But in PostgreSQL a role (user) can own several databases. The installer should complain when trying to install Openbravo with the same database name, but not when trying to install Openbravo with the same role.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0004959 closed jpabloae ant install.source tries to delete role under postgresql 
has duplicate defect 0005487 closed marvintm Check if database and user exists before cleaning/creating 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-12 11:59jpabloaeCategoryA.Installation & Platform => A. Platform (WAD, XmlEngine, SQLC)
2008-06-13 18:14cromeroStatusnew => scheduled
2008-06-13 19:59cromeroTarget Version => 2.40
2008-12-06 16:49jpabloaeRelationship addedhas duplicate 0005487
2008-12-06 16:50jpabloaeNote Added: 0011011
2009-01-19 13:04psarobeversion => trunk
2009-01-19 13:04psarobeDescription Updated
2009-01-22 09:31jpabloaeFixed in Version2.40 => trunk
2009-01-22 09:31jpabloaeTarget Version2.40 => 2.50
2009-01-22 17:57jaimetorreAssigned Tojpabloae => marvintm
2009-09-09 12:17iciordiaTarget Version2.50 =>
2010-01-21 18:45psarobeStatusscheduled => closed
2010-01-21 18:45psarobeResolutionopen => out of date

Notes
(0006301)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1913814 [^]
(0011011)
jpabloae   
2008-12-06 16:50   
From 0005487: Additionally, "Before cleaning the database it should be checked if the database exists".