Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_24.1/page/index.html

Messages associated with SQLSTATE 23502

This topic lists the messages associated with the SQLSTATE 23502.

This topic lists the messages associated with the SQLSTATE 23502.

SQLSTATE 23502 description

NOT_NULL_VIOLATION

Messages associated with this SQLState

Error messages

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 4182: NOT NULL constraint on column "string" already exists
ERROR 4183: NOT NULL constraint on column "string" does not exist

Warning messages

WARNING 2623: Column "string" definition changed to NOT NULL