14 lines
406 B
PL/PgSQL
14 lines
406 B
PL/PgSQL
BEGIN;
|
|
|
|
ALTER TABLE peripheral_sample.demo_datasets
|
|
DROP CONSTRAINT IF EXISTS demo_datasets_document_check;
|
|
|
|
ALTER TABLE peripheral_sample.demo_datasets
|
|
ADD CONSTRAINT demo_datasets_document_check CHECK ((
|
|
jsonb_typeof(document) = 'object'
|
|
AND document->>'origin' = 'synthetic'
|
|
AND document->>'generator_version' IN ('water-demo@1', 'water-demo@2')
|
|
) IS TRUE);
|
|
|
|
COMMIT;
|