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 6755.974993004@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:
> 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 by date:

Previous
From: "turing2000"
Date:
Subject: ...
Next
From: Robert Stachurski
Date:
Subject: Question about function