summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane2002-08-20 16:37:03 +0000
committerTom Lane2002-08-20 16:37:03 +0000
commit9318fa8541991db3593f5cb4275bc9540ba4ca4d (patch)
treecb12ec100f81e2d4d7effc3bcfc09db1ca081efb
parentebe1be1321fb88d7c085d39e4f01efcd352ed119 (diff)
Update expected files for recent changes of domain tests.
From Rod Taylor.
-rw-r--r--src/test/regress/expected/domain.out3
-rw-r--r--src/test/regress/expected/type_sanity.out4
2 files changed, 4 insertions, 3 deletions
diff --git a/src/test/regress/expected/domain.out b/src/test/regress/expected/domain.out
index 915b420b9a2..a67559129c5 100644
--- a/src/test/regress/expected/domain.out
+++ b/src/test/regress/expected/domain.out
@@ -143,12 +143,13 @@ create table defaulttest
( col1 ddef1
, col2 ddef2
, col3 ddef3
- , col4 ddef4
+ , col4 ddef4 PRIMARY KEY
, col5 ddef1 NOT NULL DEFAULT NULL
, col6 ddef2 DEFAULT '88'
, col7 ddef4 DEFAULT 8000
, col8 ddef5
);
+NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'defaulttest_pkey' for table 'defaulttest'
insert into defaulttest default values;
insert into defaulttest default values;
insert into defaulttest default values;
diff --git a/src/test/regress/expected/type_sanity.out b/src/test/regress/expected/type_sanity.out
index 949393386a4..68abfec74f3 100644
--- a/src/test/regress/expected/type_sanity.out
+++ b/src/test/regress/expected/type_sanity.out
@@ -16,7 +16,7 @@
SELECT p1.oid, p1.typname
FROM pg_type as p1
WHERE (p1.typlen <= 0 AND p1.typlen != -1) OR
- (p1.typtype != 'b' AND p1.typtype != 'c' AND p1.typtype != 'p') OR
+ p1.typtype not in('b', 'c', 'd', 'p') OR
NOT p1.typisdefined OR
(p1.typalign != 'c' AND p1.typalign != 's' AND
p1.typalign != 'i' AND p1.typalign != 'd') OR
@@ -60,7 +60,7 @@ WHERE (p1.typtype = 'c' AND p1.typrelid = 0) OR
-- NOTE: as of 7.3, this check finds SET, smgr, and unknown.
SELECT p1.oid, p1.typname
FROM pg_type as p1
-WHERE p1.typtype = 'b' AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
+WHERE p1.typtype in ('b','d') AND p1.typname NOT LIKE '\\_%' AND NOT EXISTS
(SELECT 1 FROM pg_type as p2
WHERE p2.typname = ('_' || p1.typname)::name AND
p2.typelem = p1.oid);