Thank you Thomas Regards Thomas
Le sam. 7 avr. 2018 à 08:01, Thomas Kellerer <spam_ea...@gmx.net> a écrit : > Adrian Klaver schrieb am 07.04.2018 um 00:02: > >> Is there a way to identify the list of statements that have to rewrite > the table. > > > > https://www.postgresql.org/docs/10/static/sql-altertable.html > > > > Notes > > > > "Adding a column with a DEFAULT clause or changing the type of an > existing column will require the entire table and its indexes to be > rewritten. > Note that this will change with Postgres 11 > > > https://www.depesz.com/2018/04/04/waiting-for-postgresql-11-fast-alter-table-add-column-with-a-non-null-default/ > > > >
