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

From aromero@dia.uned.es
Subject Problem when migrating my BB.DD Postgresql 7.2.3 to Postgresql 7.3.2
Date
Msg-id 200307062220.h66MKZ404236@hermes.uned.es
Whole thread Raw
Responses Re: Problem when migrating my BB.DD Postgresql 7.2.3 to  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List 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 by date:

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