Forum .LRN Q&A: 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, Postgresql 7.2.3 and openacs 4.6 with dotlrn 1.0 my
other system (the second) have RedHat 7.2, Postgresql 7.3.2. and openacs 4.6 with dotlrn 1.0.

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

The explanation is simple:

In PG <= 7.2 names were truncated to 31 characters.

In PG 7.3 by default the truncation length is 63 characters.

A very simple way to upgrade would be to recompile PG 7.3 after changing the name length to the old 31 character value...

Someone is already working on gathering the functions that need to be redefined using CREATE OR REPLACE, so eventually we may have an upgrade script available.