Hi Jacques, thanks for the information. On Mon, Jan 12, 2015 at 8:41 PM, Jacques Le Roux [via OFBiz] < [email protected]> wrote:
> Since you don't want to alter your DB, I guess the easier for you is to > change fieldtypepostgres.xml > Replace VARCHARby TEXT where needed. Beware though: TEXT is unlimited, > should be ok most of the time > > Jacques > > Le 12/01/2015 13:41, Anchit Jindal a écrit : > > > Hi All, > > > > I want to upgrade my old ofbiz with its latest version from trunk and > also > > want to use my existing database(which is postgres) with latest ofbiz. > For > > this i set my database name in entityengine.xml file. While running the > > ofbiz it gives error for table fields datatype mismatch e.g (Column > > [ATTR_VALUE] of table [public.CUST_REQUEST_ATTRIBUTE] of entity > > [CustRequestAttribute] is of type [text] in the database, but is defined > as > > type [VARCHAR] in the entity definition.). Can any one tell me how to > solve > > this type mismatch error for the fields except alter datatype of each > table. > > > > > > > > -- > > View this message in context: > http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247p4661254.html > To unsubscribe from Upgrade existing postgres database with latest ofbiz > give table fields mismatch error., click here > <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4661247&code=YW5jaGl0amluZGFsOTFAZ21haWwuY29tfDQ2NjEyNDd8LTEzODUxNzYwNDI=> > . > NAML > <http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Upgrade-existing-postgres-database-with-latest-ofbiz-give-table-fields-mismatch-error-tp4661247p4661363.html Sent from the OFBiz - User mailing list archive at Nabble.com.
