add to documentation - upgrade from tsearch2

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

Browse pgsql-hackers by date

  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