Max tuple size. - Mailing list pgsql-hackers

From darrenk@insightdist.com (Darren King)
Subject Max tuple size.
Date
Msg-id 9801191853.AA23492@ceodev
Whole thread Raw
Responses Re: [HACKERS] Max tuple size.  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: unixware
Next
From: Keith Parks
Date:
Subject: Re: [HACKERS] Re: varchar() troubles