Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0014777 | Openbravo ERP | 00. Application dictionary | public | 2010-10-06 10:49 | 2012-02-29 11:46 | ||||||||||||||
| Reporter | mirurita | ||||||||||||||||||
| Assigned To | migueldejuana | ||||||||||||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||||||||||||
| Status | closed | Resolution | out of date | ||||||||||||||||
| Platform | OS | 5 | OS Version | ||||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | No | ||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0014777: Create columns from DB not working with columns of type text (PostgreSQL) | ||||||||||||||||||
| Description | Error: Column not inserted due to wrong data type: Errorcolumn. Created = 0 | ||||||||||||||||||
| Steps To Reproduce | Create 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 | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | ||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||