diff options
| author | Tom Lane | 2008-12-16 00:56:12 +0000 |
|---|---|---|
| committer | Tom Lane | 2008-12-16 00:56:12 +0000 |
| commit | 794ec7b06339794ced33b98edfc25f2cee4b59dd (patch) | |
| tree | adbe469dd8c6a000e72feb8516e17f0c143c5659 /src/test | |
| parent | 1b92aeb93ea1c2c6a86b883fa17989770e50e1e1 (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.out | 4 |
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; |
