Andrew Kelly <akelly(at)transparency(dot)org> writes:
> It seems that many of the index names are being truncated
> 31 characters and this cascades to other errors.
31 was the standard name length limit in PG 7.2. If you see longer
names in a dump from a 7.2 server, then that server is *not* standard
but was built with a custom value of NAMEDATALEN. You will need to
build yours likewise. I would recommend holding a gun to someone's
head till they tell you what other nonstandard build options were
used, too ;-)
regards, tom lane