index and sequence name length limit?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема index and sequence name length limit?
Дата
Msg-id 3D4DF3EE.7070807@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: index and sequence name length limit?  (Jeff Davis <list-pgsql-general@empires.org>)
Re: index and sequence name length limit?  (Neil Conway <nconway@klamath.dyndns.org>)
Список pgsql-general
What is the limit on the length of a index or sequence's name?

I have some table with long names and I find it confusing when pgsql
truncates the table name when creating indexes or sequences (for serials).

Why does such a limit exist? I would think that since there are
virtually no limits on the size of data that a table or column can hold
there should be no limit on the length of names assigned to
tables/sequences/indexes/etc ... or if that a limit would be rather long
(say 256 characters?).

Jc


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

Предыдущее
От: Steve Lane
Дата:
Сообщение: Re: reloading really big tables
Следующее
От: Jean-Christian Imbeault
Дата:
Сообщение: COPY: SJIS file into EUC_JP DB: how?