From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "postgres hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | add to documentation - upgrade from tsearch2 |
Date: | 2008-11-19 06:06:13 |
Message-ID: | 162867790811182206w160250d4t60fb728a14714551@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-11-19 08:06:58 | Re: Replace plain-memory ordered array by binary tree in ts_stat() function. |
Previous Message | Joshua Tolley | 2008-11-19 05:17:24 | Re: Patch Review Complete: Multi-Batch Hash Join Improvements |