Re: Table name lengths...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Table name lengths...
Дата
Msg-id 22130.1062524840@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Table name lengths...  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Table name lengths...
Список pgsql-general
Ron Johnson <ron.l.johnson@cox.net> writes:
> No matter how long PostgreSQL lets you make table names, I'd stick
> with ANSI standard 31 characters.

"ANSI standard"?  SQL92 specifies that names can be up to 128 characters
long.  Perhaps there was a shorter limit in SQL89, but that ranks as
ancient history now.

(In fact, I just now realized that it says *characters*, not *bytes*,
which means that in a multibyte encoding you could need quite a bit more
than 128 bytes to meet the spec's requirement...)

            regards, tom lane

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Any way to Convince postgres to push join clause inside subquery aggregate?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: segfaults / backend crashing