Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002456Openbravo ERP00. Application dictionarypublic2008-01-03 13:322008-07-08 11:52
Reportercromero 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002456: Creating column from DB does not work properly in PostgreSQL
DescriptionIf you create a column in database:
  ismanual char(1 byte) not null default 'Y'::bpchar

and then run the 'Create columns from DB' process, generated fields are not properly created:
* It doesn't activate the Mandatory check
* Column type is set as 'String' when it should be of type 'Yes/No'
* Data lenght is not well calculated (-1 for String data types).

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003577 closed cromero Creating column from DB does not work properly P 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-08 11:52psarobeStatusresolved => closed
2008-07-08 11:52psarobeFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006045)
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=1863113 [^]
(0002925)
cromero   
2008-01-03 13:42   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500614
Originator: YES

View user_tab_columns and function AD_TABLE_IMPORT have been modified in order to fix these bugs.

Carlos Romero
Openbravo Team