table name length restriction

From: Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: table name length restriction
Date: 2008-08-15 13:21:34
Message-ID: 48A582DE.7010800@ifi.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-08-15 13:21:39 Re: table name length restriction
Previous Message Erwin Moller 2008-08-15 10:44:23 UTF8 in commandprompt (CMD) on XP fails. Tips?