Re: table name length restriction

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: table name length restriction
Дата
Msg-id 200808151621.40573.peter_e@gmx.net
обсуждение исходный текст
Ответ на table name length restriction  (Thomas Finneid <tfinneid@student.matnat.uio.no>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Finneid
Дата:
Сообщение: table name length restriction
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Killing active users