Skip site navigation (1) Skip section navigation (2)

Re: BUG #3682: Incomplete database restore

From: "Gary Chambers" <gwchamb(at)gmail(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "PostgreSQL Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3682: Incomplete database restore
Date: 2007-10-22 03:17:49
Message-ID: 302670f20710212017x377ce432g550cf5d8b92fbb03@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Heikki...

> Then I edited wikidb-psql, changing those "public.tsvector" datatypes to
> just "tsvector". After that:
>  psql wikidb < wikidb-psql

> And got no errors.

Okay, thanks!  I hadn't removed the two instances of the schema
prepending the tsvector type.  I can now import the data into
8.3beta1.  The mediawiki software is still broken, but that's outside
the scope of this discussion.

On more point that I might mention when using the removets2 script (in
the case of the Wiki database at least) is that it appears that one
must omit the schema parameter or else there will be many more
tsearch2-related items with which to deal.

Thanks for the help!

-- Gary Chambers

// Nothing fancy and nothing Microsoft!

In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2007-10-22 07:29:45
Subject: Re: BUG #3682: Incomplete database restore
Previous:From: Tom LaneDate: 2007-10-21 23:15:27
Subject: Re: BUG #3686: Incorrect numeric type conversion to long in plpythonu

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group