Re: Truncation on restore - Mailing list pgsql-novice

From Tom Lane
Subject Re: Truncation on restore
Date
Msg-id 17451.1070899833@sss.pgh.pa.us
Whole thread Raw
In response to Truncation on restore  (Andrew Kelly <akelly@transparency.org>)
List pgsql-novice
Andrew Kelly <akelly@transparency.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: duplicate entries on primary key
Next
From: Josh Berkus
Date:
Subject: Re: duplicate entries on primary key