diff options
| author | Peter Eisentraut | 2014-08-29 04:01:34 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2014-08-29 04:26:17 +0000 |
| commit | 65c9dc231a261691c76550f61f5b22f954dfcfd5 (patch) | |
| tree | e25db03cd577b39a75baf088242ad6387f1e101c /src/test | |
| parent | 14b7c8f2d062d50f2ad5d306c5cc26b7ec5cf11e (diff) | |
Assorted message improvements
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/updatable_views.out | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/updatable_views.out b/src/test/regress/expected/updatable_views.out index ea9197ab1d..6576c47451 100644 --- a/src/test/regress/expected/updatable_views.out +++ b/src/test/regress/expected/updatable_views.out @@ -151,11 +151,11 @@ DETAIL: Views containing HAVING are not automatically updatable. HINT: To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule. DELETE FROM ro_view4; ERROR: cannot delete from view "ro_view4" -DETAIL: Views that return aggregate functions are not automatically updatable +DETAIL: Views that return aggregate functions are not automatically updatable. HINT: To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule. DELETE FROM ro_view5; ERROR: cannot delete from view "ro_view5" -DETAIL: Views that return window functions are not automatically updatable +DETAIL: Views that return window functions are not automatically updatable. HINT: To enable deleting from the view, provide an INSTEAD OF DELETE trigger or an unconditional ON DELETE DO INSTEAD rule. DELETE FROM ro_view6; ERROR: cannot delete from view "ro_view6" @@ -1497,7 +1497,7 @@ SELECT * FROM base_tbl; ALTER VIEW rw_view1 SET (check_option=here); -- invalid ERROR: invalid value for "check_option" option -DETAIL: Valid values are "local", and "cascaded". +DETAIL: Valid values are "local" and "cascaded". ALTER VIEW rw_view1 SET (check_option=local); INSERT INTO rw_view2 VALUES (-20); -- should fail ERROR: new row violates WITH CHECK OPTION for view "rw_view1" |