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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
Дата
Msg-id 27187.974954354@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)  (George Armhold <armhold@cs.rutgers.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Roger T. Alexander"
Дата:
Сообщение: Problem building PostgreSQL using Cygwin
Следующее
От: "Richard Huxton"
Дата:
Сообщение: Re: Getting started on Linux RH6.2 ...