Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2
От | aromero@dia.uned.es |
---|---|
Тема | Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2 |
Дата | |
Msg-id | 200307062220.h66MKZ404236@hermes.uned.es обсуждение исходный текст |
Ответы |
Re: Problem when migrating my BB.DD Postgresql 7.2.3 to
|
Список | pgsql-admin |
Hi, I have two system. The first system have RetHat 7.2 and Postgresql 7.2.3, my other system (the second) have RedHat 7.2 and Postgresql 7.3.2. I have expoted the data base of my first system (Postgresql 7.2.3)with command pg_dump data_base name > export.dmp. I later import (the file export.dmp) in my second system (with Postgresql 7.3.2) with command psql data_base name < export.dmp. Until here, everything seems well, but, when I am proving my second system with the data base imported already, I have a serious error. I verify after of several tests and this error happens when the system is calling to function of but of 31 character. In Postgresql 7.2.3 the name function it truncated them to 31 character. The problem is what when I export the function name are exported truncated, however in Postgres 7.3.2 it don�t truncated to 31 character and my system it called them without truncated. Why the name function it truncates them in Postgresql 7.2.3 and Postgresql 7.3.2 no? it depends some variable of configuation of Postgresql 7.3.2. I don�t understand this. Everybody this has happened him. Thank you for advance. Angel
В списке pgsql-admin по дате отправления: