Hello I migrated database cluster from 8.1 to 8.3, and I had problem with tsvector domain. I imported tsearch2 module into template1 and then I started import of complete dump - but public.tsvectors wasn't be known - and I got message
ERROR: type "tsvector" is only a shell LINE 5: fulltext_index tsvector After some searching I found so databases are created from template0, not template1, so my template1 modification was nonsense. DROP DATABASE brigady; CREATE DATABASE brigady WITH TEMPLATE = template0 ENCODING = 'UTF8'; so It needs import tsearch2.sql after every database creation I am missing this information in documentation. regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers