Hello, I use tinyERP version 4.2.2 and found that the size of the column "name" in different tables varies as follows:
purchase_order_line 64 chars sale_order_line 256 chars account_invoice_line 256 chars stock_move 64 chars account_move 64 chars account_move_line 64 chars I also noticed that the content of the column "name" is copied form the table purchase_order_line or sale_order_line to the table stock_move during a packing operation like IN:xx or OUT:xx. Obviously a copy operation to the table stock_move will fail if the length of a string in column "name" is greater than 64 chars. I came across this problem and thinking of extending the size of the column "name" in the tables stock_move and purchase_order_line to 256 chars with an sql command like ALTER TABLE stock_move ALTER COLUMN name character varying(256); The tables are already populated with user data. Is there any problem if I change the size of the column as mentioned above now? I there any table other that stock_move where the contents of the column "name" from sale_order_line or purchase_order_line or account_invoice_line are copied to? Any other suggestion or workaround? I shall be thankful for your co-operation. ------------------------ Gholam Quader -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=32743#32743 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
