Skip site navigation (1) Skip section navigation (2)

Re: Tsearch2 Trigger Problem: pg_catalog.simple does not exist

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: PgSql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tsearch2 Trigger Problem: pg_catalog.simple does not exist
Date: 2009-02-11 16:11:25
Message-ID: 162867790902110811q14e9ad8cp81dba40583de18d5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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(at)selestial(dot)com>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2009-02-11 16:26:06
Subject: Re: Pet Peeves?
Previous:From: Tom LaneDate: 2009-02-11 16:00:31
Subject: Re: encoding of PostgreSQL messages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group