aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2009-11-03 14:52:10 +0000
committerPeter Eisentraut <peter_e@gmx.net>2009-11-03 14:52:10 +0000
commit16cd34a4352cc61d52b0aa99a8ece0926d236b03 (patch)
tree468a694378de1a08d2d6b1c7d4d0cb97a80c8e37
parent2e3b16c8ba22991c4c1e165cf02050ca89309c05 (diff)
downloadpostgresql-16cd34a4352cc61d52b0aa99a8ece0926d236b03.tar.gz
postgresql-16cd34a4352cc61d52b0aa99a8ece0926d236b03.zip
Fix regression tests for psql \d view patch
-rw-r--r--src/test/regress/expected/polymorphism.out16
-rw-r--r--src/test/regress/sql/polymorphism.sql2
2 files changed, 9 insertions, 9 deletions
diff --git a/src/test/regress/expected/polymorphism.out b/src/test/regress/expected/polymorphism.out
index 36b31f09f43..cc104522b0c 100644
--- a/src/test/regress/expected/polymorphism.out
+++ b/src/test/regress/expected/polymorphism.out
@@ -1350,14 +1350,14 @@ select * from dfview;
4567890123456789 | -4567890123456789 | 4567890123456789 | -4567890123456789
(5 rows)
-\d dfview
- View "public.dfview"
- Column | Type | Modifiers
---------+--------+-----------
- q1 | bigint |
- q2 | bigint |
- c3 | bigint |
- c4 | bigint |
+\d+ dfview
+ View "public.dfview"
+ Column | Type | Modifiers | Storage | Description
+--------+--------+-----------+---------+-------------
+ q1 | bigint | | plain |
+ q2 | bigint | | plain |
+ c3 | bigint | | plain |
+ c4 | bigint | | plain |
View definition:
SELECT int8_tbl.q1, int8_tbl.q2, dfunc(int8_tbl.q1, int8_tbl.q2, int8_tbl.q1 > int8_tbl.q2 AS flag) AS c3, dfunc(int8_tbl.q1, int8_tbl.q1 < int8_tbl.q2 AS flag, int8_tbl.q2 AS b) AS c4
FROM int8_tbl;
diff --git a/src/test/regress/sql/polymorphism.sql b/src/test/regress/sql/polymorphism.sql
index 2071ce63da7..3c8ab5d79b2 100644
--- a/src/test/regress/sql/polymorphism.sql
+++ b/src/test/regress/sql/polymorphism.sql
@@ -741,7 +741,7 @@ CREATE VIEW dfview AS
select * from dfview;
-\d dfview
+\d+ dfview
drop view dfview;
drop function dfunc(anyelement, anyelement, bool);