Re: Problem when migrating my BB.DD Postgresql 7.2.3 to

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?