No you don't. CHECK constraints always work. Maybe you are thinking about foreign key constraints, which for backwards compatibility are off by default, unles

No you don't. CHECK constraints always work. Maybe you are thinking about foreign key constraints, which for backwards compatibility are off by default, unless you use a compile-time option to make then on by default.