summaryrefslogtreecommitdiff
path: root/src/test/regress/input/constraints.source
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/input/constraints.source')
-rw-r--r--src/test/regress/input/constraints.source4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source
index 37d06b0127a..16468b20afb 100644
--- a/src/test/regress/input/constraints.source
+++ b/src/test/regress/input/constraints.source
@@ -148,7 +148,7 @@ DROP TABLE INSERT_CHILD;
--
CREATE TABLE ATACC1 (TEST INT
- CHECK NO INHERIT (TEST > 0));
+ CHECK (TEST > 0) NO INHERIT);
CREATE TABLE ATACC2 (TEST2 INT) INHERITS (ATACC1);
-- check constraint is not there on child
@@ -158,7 +158,7 @@ INSERT INTO ATACC1 (TEST) VALUES (-3);
DROP TABLE ATACC1 CASCADE;
CREATE TABLE ATACC1 (TEST INT, TEST2 INT
- CHECK (TEST > 0), CHECK NO INHERIT (TEST2 > 10));
+ CHECK (TEST > 0), CHECK (TEST2 > 10) NO INHERIT);
CREATE TABLE ATACC2 () INHERITS (ATACC1);
-- check constraint is there on child