Re: Overflow of attmissingval is not handled gracefully

Andrew Dunstan writes: > On 2/28/22 18:21, Tom Lane wrote: >> regression=# create table foo(f1 int); >> CREATE TABLE >> regression=# alter table foo add column bar text default repeat('xyzzy', >> 100); >> ERROR: row is too big: size 57416, maximum size 8160 >> >> I think the simplest

Re: Overflow of attmissingval is not handled gracefully

On 2/28/22 18:21, Tom Lane wrote: > Consider this admittedly-rather-contrived example: > > regression=# create table foo(f1 int); > CREATE TABLE > regression=# alter table foo add column bar text default repeat('xyzzy', > 100); > ERROR: row is too big: size 57416, maximum size 8160 > >

Overflow of attmissingval is not handled gracefully

Consider this admittedly-rather-contrived example: regression=# create table foo(f1 int); CREATE TABLE regression=# alter table foo add column bar text default repeat('xyzzy', 100); ERROR: row is too big: size 57416, maximum size 8160 Since the table contains no rows at all, this is a