summaryrefslogtreecommitdiff
path: root/src/test
diff options
context:
space:
mode:
authorTom Lane2008-12-16 00:56:12 +0000
committerTom Lane2008-12-16 00:56:12 +0000
commit794ec7b06339794ced33b98edfc25f2cee4b59dd (patch)
treeadbe469dd8c6a000e72feb8516e17f0c143c5659 /src/test
parent1b92aeb93ea1c2c6a86b883fa17989770e50e1e1 (diff)
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.
Diffstat (limited to 'src/test')
-rw-r--r--src/test/regress/expected/create_view.out4
1 files changed, 2 insertions, 2 deletions
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;