[YSQL] ERROR: row is too big, TOAST support

[jaki]

Jira Link: DB-1486 This is taken from the arrays Postgres regress test.

-- Check that arrays of composites are safely detoasted when needed
create temp table src (f1 text);
insert into src
  select string_agg(random()::text,'') from generate_series(1,10000);
ERROR:  row is too big: size 121224, maximum size 8160

It should not error.

[ndeodhar]

This is related to TOAST-able columns (we use postgres storage for temp tables): https://www.postgresql.org/docs/9.5/storage-toast.html

The same example works in vanilla postgres and in YB for regular tables.