Add support for temporary views, including documentation and regression
Neil Conway <neilc@samurai.com>
Add support for temporary views, including documentation and regression tests. Contributed by Koju Iijima, review from Neil Conway, Gavin Sherry and Tom Lane. Also, fix error in description of WITH CHECK OPTION clause in the CREATE VIEW reference page: it should be "CASCADED", not "CASCADE".
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/create_table.sgml | modified | +7 −7 |
| doc/src/sgml/ref/create_view.sgml | modified | +36 −11 |
| src/backend/commands/view.c | modified | +71 −3 |
| src/backend/parser/gram.y | modified | +18 −7 |
| src/include/commands/view.h | modified | +2 −2 |
| src/test/regress/expected/create_view.out | modified | +246 −0 |
| src/test/regress/sql/create_view.sql | modified | +128 −0 |