|
|
|
|
|
|
Error Message
WARNING: column "..." definition changed to NOT NULL
Explanation
In a CREATE TABLE statement, you must specify NOT NULL on columns that will be given PRIMARY and FOREIGN KEY constraints. Otherwise, Vertica sets the column to NOT NULL and issues a warning.
Workaround
Always specify NOT NULL on columns that will be given PRIMARY and FOREIGN KEY constraints.