| From: | Robert Haas <rhaas(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Allow ALTER TABLE .. SET NOT NULL to skip provably unnecessary s |
| Date: | 2019-03-13 12:57:34 |
| Message-ID: | E1h43Ru-0005An-1w@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Allow ALTER TABLE .. SET NOT NULL to skip provably unnecessary scans.
If existing CHECK or NOT NULL constraints preclude the presence
of nulls, we need not look to see whether any are present.
Sergei Kornilov, reviewed by Stephen Frost, Ildar Musin, David Rowley,
and by me.
Discussion: http://postgr.es/m/81911511895540@web58j.yandex.ru
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/bbb96c3704c041d139181c6601e5bc770e045d26
Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml | 13 +++-
src/backend/commands/tablecmds.c | 111 ++++++++++++++++++++++++------
src/test/regress/expected/alter_table.out | 54 +++++++++++++++
src/test/regress/sql/alter_table.sql | 40 +++++++++++
4 files changed, 195 insertions(+), 23 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2019-03-13 13:28:25 | pgsql: Include all columns in default names for foreign key constraints |
| Previous Message | Magnus Hagander | 2019-03-13 12:44:28 | pgsql: Remove extra comma |