Max tuple size.

From: darrenk(at)insightdist(dot)com (Darren King)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Max tuple size.
Date: 1998-01-19 18:53:25
Message-ID: 9801191853.AA23492@ceodev
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shiby Thomas 1998-01-19 19:34:15 debug flag
Previous Message Keith Parks 1998-01-19 18:52:52 Re: [HACKERS] Re: varchar() troubles