Postgres Pro
Downloads
Home   >   mailing lists

Re: tsearch2 question - Mailing list pgsql-sql

From Wei Weng
Subject Re: tsearch2 question
Date
Msg-id Pine.LNX.4.56.0309261431540.10646@localhost.localdomain
Whole thread Raw
In response to tsearch2 question  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
When I ran psql testdb < untsearch2.sql

I got the following error message:

psql:untsearch2.sql:15: ERROR:  RemoveAggregate: aggregate stat(tsvector) 
does not exist

I didn't really do anything before this. Only dropped the trigger and gist 
index I created (in order to use tsearch2), and alter table testtb drop 
column idxtest tsvector.

Where did I do wrong?

Thanks

Wei

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Capturing pgsql ERRORS/NOTICES to file
Next
From: "George Weaver"
Date:
Subject: Re: Capturing pgsql ERRORS/NOTICES to file