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

2011-03-13 Thread Rob Sargent
Brian Hirt wrote: On Mar 13, 2011, at 12: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 2712 for index "ir_tran

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

2011-03-13 Thread Brian Hirt
On Mar 13, 2011, at 12: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 2712 for index "ir_translation_ltns" > HINT: Values larger than 1/3 of a buffer

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

2011-03-13 Thread Dmitriy Igrishin
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 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

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

2011-03-13 Thread Viktor Nagy
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