Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch consistency trigger on inheritated table - Mailing list pgsql-general

From Björn Metzdorf
Subject Re: tsearch consistency trigger on inheritated table
Date
Msg-id 037b01c28b2f$f5ac9fd0$81c206d4@office.turtleentertainment.de
Whole thread Raw
In response to tsearch consistency trigger on inheritated table  ("Bjoern Metzdorf" <bm@turtle-entertainment.de>)
List pgsql-general
Tree view 
> Well, it turned out that column "title" was "character(100)" and not
"text".
> It seems that function tsearch depends on columns being "text". Is there
> some way to circumwent this? txt2txtidx works with "character" too.

The corresponding code part in txtidx.c:

if (numattr < 0 || (!(oidtype == TEXTOID || oidtype == VARCHAROID)))
{
   elog(NOTICE, "TSearch: can not find field '%s'", trigger->tgargs[i]);
   continue;
}

Question is, do I break anything if I add "|| oidtype == CHARACTEROID" ?

Regards,
Bjoern

pgsql-general by date:

Previous
From: Artur Rataj
Date:
Subject: Re: Comparing strings with non-ASCII characters
Next
From: Björn Metzdorf
Date:
Subject: Re: tsearch consistency trigger on inheritated table