Re: [GENERAL] table name length restriction

2008-08-15 Thread Peter Eisentraut
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 reasona

[GENERAL] table name length restriction

2008-08-15 Thread Thomas Finneid
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 m