tsearch consistency trigger on inheritated table

Поиск
Список
Период
Сортировка
От Bjoern Metzdorf
Тема tsearch consistency trigger on inheritated table
Дата
Msg-id 013e01c28aa0$e1b178a0$0564a8c0@toolteam.net
обсуждение исходный текст
Ответы Re: tsearch consistency trigger on inheritated table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tommi Mäkitalo
Дата:
Сообщение: Re: C++: get value for integral types?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: tsearch consistency trigger on inheritated table