Tsearch2 Trigger Problem: pg_catalog.simple does not exist
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
RTFM!
Just read the part about ditching the tsearch2 function. Sincere apologies.
Howard.
Howard Cole wrote:
Show quoted text
execute procedure tsearch2('fts','column1','column2');
Hello
this bug was reported two weeks ago and it is fixed in 8.3.6.
regards
Pavel Stehule
2009/2/11 Howard Cole <howardnews@selestial.com>:
Show quoted text
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--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general