Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: George Armhold <armhold(at)cs(dot)rutgers(dot)edu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Date: 2000-11-23 04:39:14
Message-ID: 27187.974954354@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

George Armhold <armhold(at)cs(dot)rutgers(dot)edu> writes:
>> So, how about showing us the first 20 or so lines of db.backup? You
>> can't really expect us to guess much from this amount of info ...

> Fair enough question.

> CREATE TABLE pfam (swiss_id varchar(16) NOT NULL, pfam_family
> varchar(32), comment varchar(80), sequence_data varchar(-5));

Hrm. varchar(-5) is pretty obviously broken :-(. I don't want to
guess what sort of aberration prompted that output from pg_dump
--- 6.3.2 is before my time with Postgres. Try editing the dump
file to have a more reasonable value for the varchar max width,
and see how it goes...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steffen Schmidt 2000-11-23 09:08:12 Running several postmaster using same database in parallel
Previous Message Roger T. Alexander 2000-11-23 03:20:46 Problem building PostgreSQL using Cygwin