Thread: table name length restriction

Hi

I (well, a colleague of mine) have a problem where table names are
longer than the 70 char limit. The names must be human readable, i.e. no
synthetic name mapping etc. The table creation and the created name are
executed automatically, so an algorithm to create a fancy short name is
just more pain than its worth.

First question is, what is the rationale behind having a limit on the
table name?

Secondly Any ideas on how to solve this problem? Is the name length
limit configurable?

regards

thomas

Am Friday, 15. August 2008 schrieb Thomas Finneid:
> First question is, what is the rationale behind having a limit on the
> table name?

Is is an implementation detail.  Fixed-length name fields are more efficient
to process.  And when you have fixed-length fields you need to choose some
reasonable limit to avoid wasting too much space.

> Secondly Any ideas on how to solve this problem? Is the name length
> limit configurable?

Yes, edit NAMEDATALEN in src/include/pg_config_manual.h and rebuild.