postgres.git / summary / log / commit / refs

commit    16cd34a4352cc61d52b0aa99a8ece0926d236b03
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Tue Nov 03 14:52:10 2009 +0000

    Fix regression tests for psql \d view patch


 src/test/regress/expected/polymorphism.out | 16 ++++++++--------
 src/test/regress/sql/polymorphism.sql      |  2 +-
 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);


[parent: 2e3b16c8ba22]