From 9318fa8541991db3593f5cb4275bc9540ba4ca4d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 20 Aug 2002 16:37:03 +0000 Subject: [PATCH] Update expected files for recent changes of domain tests. From Rod Taylor. --- src/test/regress/expected/domain.out | 3 ++- src/test/regress/expected/type_sanity.out | 4 ++-- 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); -- 2.39.5