The following alter table with default set to very large text used to work
in Postgres 10 but fails in Postgres 12 with *ERROR:  row is too big: size
12960, maximum size 8160*

create table test (id int);
alter table test1 add column license text DEFAULT   '<insert default text
with size more than 8160 >'


The following two variants works in Postgres 12 without any error:

create table test (id int);
alter table test1 add column license text
alter table test1 alter column license SET DEFAULT   '<insert default text
with size more than 8160 >'

create table test (id int, license text  DEFAULT   '<insert default text
with size more than 8160 >' );

Thanks in advance.

Reply via email to