Re: Name limitation question

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Name limitation question
Дата
Msg-id 200306211135.18984.josh@agliodbs.com
обсуждение исходный текст
Ответ на Name limitation question  ("Laura Nichols" <LNichols@oacis.com>)
Ответы Re: Name limitation question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Laura,

> I have a quick question.  Is there a limit to the length of a table name /
> column name / procedure name?  For example, Sybase has a limit of 32
> characters for stored procedure names, or some such.  Is there such a limit
> in PostgreSQL?

We had a limit of first 31, then 63 characters.   Either in 7.3 or in 7.4
(beta) that was extended to 128 characters, which should be enough for
anybody.  Unfortunately, I'm not sure what versions of Postgres each of these
limits is associated with, but I'm sure that someone else on this list will
speak up.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: connectby(... pos_of_sibling)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Name limitation question