Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
От | George Armhold |
---|---|
Тема | Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) |
Дата | |
Msg-id | 004701c0563e$14084020$a974bf18@KLAMATH обсуждение исходный текст |
Ответ на | trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) (George Armhold <armhold@cs.rutgers.edu>) |
Ответы |
Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)
|
Список | pgsql-general |
Earlier in the week I was having problems moving from PG 6.3.2 under IRIX to version 7.0.2 under Linux. I noticed that pg_dump was creating bogus (negative value) entries for varchar fields that were initiallly created with no maximum length constraint. Tom Lane suggested the following: > 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. This fixed most of the problems. The one other thing I had to do was rename a field "offset" to "my_offset" throughout all my tables. Apparently this is a reserved word in the current version? I still have some more testing to do, but I seem to have things working now. Thanks to the group, and Tom Lane in particular.
В списке pgsql-general по дате отправления: