Re: tsearch2 upgrade problem and mediawiki

From: Jon Lapham <lapham(at)jandr(dot)org>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2 upgrade problem and mediawiki
Date: 2007-08-02 19:44:54
Message-ID: 46B23436.3090100@jandr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton wrote:
> Try just adding the column, I'm guessing it was dropped while you were
> taking out the old tsearch2 installation.
> ALTER TABLE pagecontent ADD COLUMN textvector tsvector;

Thanks, that fixed the problem.

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham <lapham(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gavin M. Roy 2007-08-02 20:39:12 Re: What do people like to monitor (or in other words, what might be nice in pgsnmpd)?
Previous Message Guy Fraser 2007-08-02 19:31:18 Re: array_to_set functions