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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings