c2c-oerpscenario team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello ViktorNagy,

I have teated your scenario at my end with more then 3000 line on product description field and then translated it.
But all are working as expected and I am not faced any type of error.

So would you please check it again and notify us.

For now I am closing this bug if you still faced the problem then you
can reopen this.

Thanks for the understanding!

** Changed in: openobject-server
       Status: New => Invalid

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/754582

Title:
  indexing ir_translations fails for long tranlatable strings

Status in OpenERP Server:
  Invalid

Bug description:
  take the example of a long-long product description, and translate it
  to a different language, I've ended up with the following error:

  index row size 3120 exceeds maximum 2712 for index "ir_translation_ltns"
  HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
  Consider a function index of an MD5 hash of the value, or use full text
  indexing.

  the solution is here
  http://archives.postgresql.org/pgsql-general/2011-03/msg00430.php

  according to the discussion that follows, it seems to be wise to use md5 (os similar) indexing by default. If this is the case, how would one implement it?
  (Actually, a simple ALTER TABLE did it for the existing database)