Re: Problem when migrating my BB.DD Postgresql 7.2.3 to - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Problem when migrating my BB.DD Postgresql 7.2.3 to
Date
Msg-id 20030706163140.A63952-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2  (aromero@dia.uned.es)
List pgsql-admin
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?



pgsql-admin by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore
Next
From: "Soeren Laursen"
Date:
Subject: Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error