-- Add the check constraint
alter table public.test_partition_10_25 add constraint test_partition_10_25_constraint CHECK (id >= 10 AND id <25) NOT VALID;
update pg_constraint pgc
SET convalidated = true
FROM pg_class c
WHERE
c.oid = pgc.conrelid
AND connamespace = 'public'::regnamespace::oid
AND c.relname = 'test_partition_10_25'
AND conname = 'test_partition_10_25_constraint';
Incomplete list of macOS defaults commands with demos ✨
You've already copied `defaults write` commands. Sometimes you don't know what they do and are not sure they still work. This list of macOS defaults commands is here to help.
G. Ottoni, and B. Liu. 2021 IEEE/ACM International Symposium on Code Generation and Optimization (CGO), page 340-350. Los Alamitos, CA, USA, IEEE Computer Society, (March 2021)