Max tuple size.

Поиск
Список
Период
Сортировка
От darrenk@insightdist.com (Darren King)
Тема Max tuple size.
Дата
Msg-id 9801191853.AA23492@ceodev
обсуждение исходный текст
Ответы Re: [HACKERS] Max tuple size.  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
This comes up since the varchar will no longer be padded...

Should the user be allowed to create a table with fields that
would go over the maximum tuple size if all fields were max'd?

Example...with a block size of 8192...

create table foo (a varchar(4000), b varchar(4000), c varchar(500));

It's possible that a valid tuple according to the table definition
will be rejected internally.

6.2 lets me create the above table, but won't let me insert in it
unless at least one of the fields is null.  6.3 will allow the row
as long as they collectively aren't more than the MAXTUPLEN.

Should postgres issue a warning or an error about this condition
when the table is created?

darrenk

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: unixware
Следующее
От: Keith Parks
Дата:
Сообщение: Re: [HACKERS] Re: varchar() troubles