]> granicus.if.org Git - postgresql/commit
Enforces NOT NULL constraints to be applied against new PRIMARY KEY
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 2 Jan 2003 19:29:22 +0000 (19:29 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 2 Jan 2003 19:29:22 +0000 (19:29 +0000)
commit0a02d47a113ae67b35c5fa060bac6114609f6c5b
tree4e7a7592e9a9226d53ed663e6558c3cad872ba1b
parent2f86f146d9039c2ca0e16f333ec8a0d62491d984
Enforces NOT NULL constraints to be applied against new PRIMARY KEY
columns in DefineIndex.  So, ALTER TABLE ... PRIMARY KEY will now
automatically add the NOT NULL constraint.  It appeared the alter_table
regression test wanted this to occur, as after the change the regression
test better matched in inline 'fails'/'succeeds' comments.

Rod Taylor
src/backend/commands/indexcmds.c
src/backend/parser/analyze.c
src/test/regress/expected/alter_table.out
src/test/regress/expected/inherit.out
src/test/regress/sql/alter_table.sql
src/test/regress/sql/inherit.sql