Author: jacopoc
Date: Tue Aug 25 07:46:31 2015
New Revision: 1697590
URL: http://svn.apache.org/r1697590
Log:
Reverted 1530237: the sql type for Postgres for "comments" and "description"
fields was changed from VARCHAR(255) to TEXT; the new TEXT type allows strings
of any length; however all other types definitions (MySQL, Derby etc...) are
using VARCHAR(255) thus limiting the length of "comments" and "description"
fields to 255 characters.
By reverting this change we make sure that the Postgres db will be consistent
with the other dbs.
Modified:
ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
Modified: ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml?rev=1697590&r1=1697589&r2=1697590&view=diff
==============================================================================
--- ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml (original)
+++ ofbiz/trunk/framework/entity/fieldtype/fieldtypepostgres.xml Tue Aug 25
07:46:31 2015
@@ -46,8 +46,8 @@ under the License.
<field-type-def type="long-varchar" sql-type="VARCHAR(255)"
java-type="String"/>
<field-type-def type="very-long" sql-type="TEXT" java-type="String"/>
- <field-type-def type="comment" sql-type="TEXT" java-type="String"/>
- <field-type-def type="description" sql-type="TEXT" java-type="String"/>
+ <field-type-def type="comment" sql-type="VARCHAR(255)" java-type="String"/>
+ <field-type-def type="description" sql-type="VARCHAR(255)"
java-type="String"/>
<field-type-def type="name" sql-type="VARCHAR(100)" java-type="String"/>
<field-type-def type="value" sql-type="VARCHAR(255)" java-type="String"/>
