On Sun, 6 Jul 2003 [EMAIL PROTECTED] 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? ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly