Re: table name length restriction

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
Subject: Re: table name length restriction
Date: 2008-08-15 13:21:39
Message-ID: 200808151621.40573.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2008-08-15 13:43:49 Killing active users
Previous Message Thomas Finneid 2008-08-15 13:21:34 table name length restriction