Tsearch2 Trigger Problem: pg_catalog.simple does not exist

Поиск
Список
Период
Сортировка
От Howard Cole
Тема Tsearch2 Trigger Problem: pg_catalog.simple does not exist
Дата
Msg-id 4992E0D4.7060708@selestial.com
обсуждение исходный текст
Ответы Re: Tsearch2 Trigger Problem: pg_catalog.simple does not exist  (Howard Cole <howardnews@selestial.com>)
Re: Tsearch2 Trigger Problem: pg_catalog.simple does not exist  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Hi,

I am in the process of updating a database from 8.2 to 8.3 and need a
little help with the tsearch2 update.

Prior to restoring my 8.3 backup, I ran the tsearch2.sql on the new
database, however I am having a little problem with triggers - when I
run an update on a table I get the following error:

Error: column "pg_catalog.simple" does not exist
SQL state: 42703.

I am fairly sure that the errors are down to the trigger, which is
defined as follows:

create trigger fts_trigger
before insert or update
on mytable
for each row
execute procedure tsearch2('fts','column1','column2');


N.B, the following queries work fine.
select to_tsquery('pg_catalog.simple','curious');
select to_tsquery('curious');

What am I missing?

Thanks

Howard
htttp://www.selestial.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Serge Fonville
Дата:
Сообщение: Re: PostgreSQL clustering with DRBD
Следующее
От: Csaba Együd
Дата:
Сообщение: Re: Pl/PgSQL String formatting like raise?