[OpenFTS-general] Length of the txtidx column and length of the text to be indexed

[Natasa B. <n.b...@zi...>]

Hi,

I have created a ftext table which has the following structure:
ftext (docid number,
        text_to_index text,
        text_index txtidx)...

Unfortunatelly, when I try run=20

$idx->index($docid, $text_to_index)

the problem is if a text_to_index is longer than 85967 then the =
following code in sub _flash of Index.pm fails....

"   if ( defined $list && length $list ) {
                print "Za doc $tid duzina je $duzina  KRAJ \n!";
                $success &&=3D $self->{DBI}->do(
                        "update $self->{TABLE} set $self->{TXTIDX_FIELD} =
=3D '$list' where $self->{IDNAME} =3D $tid;"
                );
        } else {...
"
I see two possible ways to solve this:

1) Well, I know it is about the length of the db column which is here =
represented as type txtidx, but cannot see how actually to make this =
column bigger (as I saw in Pg documentation there is a small chance to =
do that, since the type is already created with internal length=3D -1 =
(variable length) and I do not see much other possibilities ... but =
maybe that is rather Pg support related..)...

2) Or, shall I split the bigger texts into several rows with length less =
than 85967...

Best regards,
N.