Postgres 12 - default value for text column

2020-08-04 Thread Raj Gandhi
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 '' The following two variants works in P

Re: Postgres 12 - default value for text column

2020-08-04 Thread Raj Gandhi
Great, thanks David for the explanation. On Tue, Aug 4, 2020 at 4:59 PM David Rowley wrote: > On Wed, 5 Aug 2020 at 08:36, Raj Gandhi wrote: > > The following alter table with default set to very large text used to > work in Postgres 10 but fails in Postgres 12 with ERROR: ro