Max tuple size.
Darren King <darrenk@insightdist.com>
From: darrenk@insightdist.com (Darren King)
To: pgsql-hackers@postgresql.org
Date: 1998-01-19T18:53:25Z
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