From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | <aromero(at)dia(dot)uned(dot)es> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Problem when migrating my BB.DD Postgresql 7.2.3 to |
Date: | 2003-07-06 23:35:15 |
Message-ID: | 20030706163140.A63952-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Sun, 6 Jul 2003 aromero(at)dia(dot)uned(dot)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 dont 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?
From | Date | Subject | |
---|---|---|---|
Next Message | Soeren Laursen | 2003-07-07 08:12:12 | Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore fails - UNICODE error |
Previous Message | Markus Bertheau | 2003-07-06 22:48:19 | Re: Migrating from 7.1 to 7.2 using pg_dump/pg_restore |