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

Note: For information about troubleshooting Vertica error messages, see the Vertica Knowledge Base and the Vertica Forum.