Re: [GENERAL] maximal length of varchar

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] maximal length of varchar
Дата
Msg-id 199906241608.MAA17542@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] maximal length of varchar  (guenther mair <mairg@efferd.nettz.com>)
Список pgsql-general
>
> > prova=> create table a1(a varchar(99999));
> > ERROR:  length for type 'varchar' cannot exceed 8064
> > prova=> create table a1(a varchar(8064));
> > CREATE
>
> thanks, for this quick answer!
>
> i did the test by myself and found out, that on the my system (freebsd
> 3.2) where i do actualy my tests, varchar is limited to 4096. this creates
> the problem of plattfrom dependence.

I changed This in 6.5 to something near 8k.  It may be too large because
I am not sure how a row is going to be updated inside the page.  Not
sure if this is an issue.


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Limitation
Следующее
От: "Roeland M.J. Meyer"
Дата:
Сообщение: RE: [GENERAL] Limitation