Re: [GENERAL] Values larger than 1/3 of a buffer page cannot be indexed.

thanks, this worked. On Sun, Mar 13, 2011 at 7:05 PM, Dmitriy Igrishin wrote: > Hey Viktor, > > 2011/3/13 Viktor Nagy > >> hi, >> >> when trying to insert a long-long value, I get the following error: >> >> index row size 3120 exceeds maximum 27

[GENERAL] Values larger than 1/3 of a buffer page cannot be indexed.

hi, when trying to insert a long-long value, I get 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. is