Обсуждение: Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2

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

On Sun, 6 Jul 2003 aromero@dia.uned.es wrote:

> 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?

I believe the default name length maximum went up to 64 in 7.3. I couldn't
completely follow the text, but is it that you're calling functions with
the untruncated names but the names came in truncated from the dump?