Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) - Mailing list pgsql-general

From Tom Lane
Subject Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Date
Msg-id 27187.974954354@sss.pgh.pa.us
Whole thread Raw
In response to Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)  (George Armhold <armhold@cs.rutgers.edu>)
List pgsql-general
George Armhold <armhold@cs.rutgers.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

pgsql-general by date:

Previous
From: "Roger T. Alexander"
Date:
Subject: Problem building PostgreSQL using Cygwin
Next
From: "Richard Huxton"
Date:
Subject: Re: Getting started on Linux RH6.2 ...