From 794ec7b06339794ced33b98edfc25f2cee4b59dd Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Tue, 16 Dec 2008 00:56:12 +0000
Subject: Department of second thoughts: further experimentation with CREATE OR
 REPLACE VIEW suggests that it'd be worth spelling the error messages out in a
 little more detail.  This seems to help with localizing the problem.

---
 src/test/regress/expected/create_view.out | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/test')

diff --git a/src/test/regress/expected/create_view.out b/src/test/regress/expected/create_view.out
index 90e6c70e572..04383e43d2d 100644
--- a/src/test/regress/expected/create_view.out
+++ b/src/test/regress/expected/create_view.out
@@ -53,11 +53,11 @@ ERROR:  cannot drop columns from view
 -- should fail
 CREATE OR REPLACE VIEW viewtest AS
 	SELECT 1, * FROM viewtest_tbl;
-ERROR:  cannot change name of view column "a"
+ERROR:  cannot change name of view column "a" to "?column?"
 -- should fail
 CREATE OR REPLACE VIEW viewtest AS
 	SELECT a, b::numeric FROM viewtest_tbl;
-ERROR:  cannot change data type of view column "b"
+ERROR:  cannot change data type of view column "b" from integer to numeric
 -- should work 
 CREATE OR REPLACE VIEW viewtest AS
 	SELECT a, b, 0 AS c FROM viewtest_tbl;
-- 
cgit v1.2.3