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 6755.974993004@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:
> Hmm, I seem to be getting negative values for tables that were created
> without a maximum char length.  Is (was) it legal postgres syntax to
> say something like
>    create table foo (mytext varchar);
> without a maximum length constraint?

It was and is, but it looks like 6.3.2's pg_dump did the wrong thing
with 'em.  If you know that's how these fields were created, I'd say
that manually removing the (-5) from the table declarations is the
way to go.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "turing2000"
Дата:
Сообщение: ...
Следующее
От: Robert Stachurski
Дата:
Сообщение: Question about function