diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-09-02 20:04:40 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-09-02 20:04:40 +0000 |
| commit | 8f60f43f2e23add472acd988741411e025bff87d (patch) | |
| tree | 7073d9316687201f160f5f188599b40f5c70a9e2 /src/test/regress/expected/create_view.out | |
| parent | b4d24d78a9bb8768f47bd41950b1c0a57ccd3e1a (diff) | |
| download | postgresql-8f60f43f2e23add472acd988741411e025bff87d.tar.gz | |
Department of second thoughts: make checks for replacing a view slightly
more flexible, and improve the error reporting. Also, add documentation
for REPLACE RULE/VIEW.
Diffstat (limited to 'src/test/regress/expected/create_view.out')
| -rw-r--r-- | src/test/regress/expected/create_view.out | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/create_view.out b/src/test/regress/expected/create_view.out index ade98e6c31..e4b4d7484b 100644 --- a/src/test/regress/expected/create_view.out +++ b/src/test/regress/expected/create_view.out @@ -44,14 +44,14 @@ SELECT * FROM viewtest; -- should fail CREATE OR REPLACE VIEW viewtest AS SELECT a FROM viewtest_tbl WHERE a <> 20; -ERROR: Cannot change column set of existing view viewtest +ERROR: Cannot change number of columns in view -- should fail CREATE OR REPLACE VIEW viewtest AS SELECT 1, * FROM viewtest_tbl; -ERROR: Cannot change column set of existing view viewtest +ERROR: Cannot change number of columns in view -- should fail CREATE OR REPLACE VIEW viewtest AS SELECT a, b::numeric FROM viewtest_tbl; -ERROR: Cannot change column set of existing view viewtest +ERROR: Cannot change datatype of view column "b" DROP VIEW viewtest; DROP TABLE viewtest_tbl; |