Error Messages Associated with SQLSTATE 23502
This topic lists the errors associated with the SQLSTATE 23502.
SQLSTATE 23502 Description
ERRCODE_NOT_NULL_VIOLATION
Error messages associated with this SQLState
ERROR 2416: Cannot drop NOT NULL constraint on column "string" when it is referenced in PARTITION BY expression
ERROR 2417: Cannot drop NOT NULL constraint on column "string" when it is referenced in primary key constraint
ERROR 2623: Column "string" definition changed to NOT NULL
ERROR 4182: NOT NULL constraint on column "string" already exists
ERROR 4183: NOT NULL constraint on column "string" does not exist
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.