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

From Bjoern Metzdorf
Subject tsearch consistency trigger on inheritated table
Date
Msg-id 013e01c28aa0$e1b178a0$0564a8c0@toolteam.net
Whole thread Raw
Responses Re: tsearch consistency trigger on inheritated table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

The trigger from README:

create trigger txtidxupdate before update or insert on titles
 for each row execute procedure tsearch(titleidx, title);

When using this trigger on an inheritated table (with "title" being an
inheritated column), an insert or update on the table fails stating:

NOTICE:  TSearch: can not find field 'title'
ERROR:  ExecAppend: Fail to add null value in not null attribute created

Is this possible or did I mess everything completely up?

Btw, using txt2txtidx on all rows and selecting with ## and @@ works fine,
it is just the trigger.

Regards,
Bjoern


pgsql-general by date:

Previous
From: Tommi Mäkitalo
Date:
Subject: Re: C++: get value for integral types?
Next
From: Tom Lane
Date:
Subject: Re: tsearch consistency trigger on inheritated table