Magnus Hagander <[EMAIL PROTECTED]> writes:
> On Sun, Oct 21, 2007 at 04:24:05PM -0400, Tom Lane wrote:
>> I'm pretty uncomfortable with the notion of having pg_dump deliberately
>> throw data away. Another problem is that even if we did that, it would
>> only help people who dumped their old DB w
Tom Lane wrote:
> As for the datatype issue, I wonder whether we should just advise people
> to do
> CREATE DOMAIN public.tsvector AS pg_catalog.tsvector;
> before restoring?
Would be tidier in the long run to replace the references, but that's
simpler. Could we do that automatically to the
On Sun, Oct 21, 2007 at 04:24:05PM -0400, Tom Lane wrote:
> "Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> > Perhaps we should include the functionality of that script in pg_dump.
>
> I'm pretty uncomfortable with the notion of having pg_dump deliberately
> throw data away. Another problem is
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.3b
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> Perhaps we should include the functionality of that script in pg_dump.
I'm pretty uncomfortable with the notion of having pg_dump deliberately
throw data away. Another problem is that even if we did that, it would
only help people who dumped thei
(please keep the list cc'd)
Gary Chambers wrote:
>> Ah, did you dump the database from an existing 8.2 installation? There's
>> clauses in there to create Postgres 8.2 contrib/tsearch2 types and
>> functions, which are no longer needed beacuse full-text search is now a
>> core feature. I removed t
Heikki Linnakangas wrote:
> Gary Chambers wrote:
>> The following bug has been logged online:
>>
>> Bug reference: 3682
>> Logged by: Gary Chambers
>> Email address: [EMAIL PROTECTED]
>> PostgreSQL version: 8.3beta1
>> Operating system: Mac OS X 10.4.10
>> Description:I
Gary Chambers wrote:
> The following bug has been logged online:
>
> Bug reference: 3682
> Logged by: Gary Chambers
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.3beta1
> Operating system: Mac OS X 10.4.10
> Description:Incomplete database restore
> Detail
The following bug has been logged online:
Bug reference: 3682
Logged by: Gary Chambers
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3beta1
Operating system: Mac OS X 10.4.10
Description:Incomplete database restore
Details:
After dumping a database with pg_
