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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0014777
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2010-10-06 10:492012-02-29 11:46
ReportermiruritaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionout of dateFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0014777: Create columns from DB not working with columns of type text (PostgreSQL)

DescriptionError:
Column not inserted due to wrong data type: Errorcolumn. Created = 0
Steps To ReproduceCreate a table in PostgreSQL with a column of type text
CREATE TABLE TEST_TABLE
  TEST_TABLE_ID character varying(32) NOT NULL,
  AD_CLIENT_ID character varying(32) NOT NULL,
  ad_org_id character varying(32) NOT NULL,
  created timestamp without time zone NOT NULL DEFAULT now(),
  createdby character varying(32) NOT NULL,
  updated timestamp without time zone NOT NULL DEFAULT now(),
  updatedby character varying(32) NOT NULL,
  isactive character(1) DEFAULT 'Y'::bpchar,
  errorcolumn text,
  CONSTRAINT test_table_key PRIMARY KEY (test_table_id),
  CONSTRAINT test_ad_client_log FOREIGN KEY (ad_client_id) REFERENCES ad_client (ad_client_id),
  CONSTRAINT test_ad_org_log FOREIGN KEY (ad_org_id) REFERENCES ad_org (ad_org_id)
);

Go to Application Dictionary || Tables and Columns || Table and create a new table.

Click on Create Columns from DB
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0011529 closedmigueldejuana Create columns process suggests wrong references 
related to defect 0018646 closedalostale The "Create columns from table" process does not handle BYTEA columns 

-  Notes
(0045578)
migueldejuana (viewer)
2012-02-29 11:46

 Working fine in current pi@10e3111439cc

Fixed by 0018646

- Issue History
Date Modified Username Field Change
2010-10-06 10:49 mirurita New Issue
2010-10-06 10:49 mirurita Assigned To => marvintm
2010-10-06 10:49 mirurita OBNetwork customer => No
2010-10-11 09:00 alostale Status new => scheduled
2010-10-11 09:00 alostale Assigned To marvintm => alostale
2010-10-11 09:00 alostale fix_in_branch => pi
2012-02-28 16:49 alostale Assigned To alostale => migueldejuana
2012-02-29 11:36 migueldejuana Relationship added related to 0011529
2012-02-29 11:45 migueldejuana Relationship added related to 0018646
2012-02-29 11:46 migueldejuana Note Added: 0045578
2012-02-29 11:46 migueldejuana Status scheduled => closed
2012-02-29 11:46 migueldejuana Resolution open => out of date

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker