Search Postgresql Archives

Postgres 12 - default value for text column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux