diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2014-12-13 13:56:09 -0500 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2014-12-13 13:56:09 -0500 |
| commit | e39b6f953e8c699eacd676314574ed5869ebacef (patch) | |
| tree | 420894d9b39ef8e41d302d76b14a4e7e3e54d3f6 /src/test/regress/sql/matview.sql | |
| parent | e311cd6ded096122a5f2b5cbe91bc3a9f0dda3cb (diff) | |
| download | postgresql-e39b6f953e8c699eacd676314574ed5869ebacef.tar.gz | |
Add CINE option for CREATE TABLE AS and CREATE MATERIALIZED VIEW
FabrÃzio de Royes Mello reviewed by Rushabh Lathia.
Diffstat (limited to 'src/test/regress/sql/matview.sql')
| -rw-r--r-- | src/test/regress/sql/matview.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/sql/matview.sql b/src/test/regress/sql/matview.sql index fee1ddc842..70e4492c1b 100644 --- a/src/test/regress/sql/matview.sql +++ b/src/test/regress/sql/matview.sql @@ -201,6 +201,8 @@ SET ROLE user_dw; CREATE TABLE foo_data AS SELECT i, md5(random()::text) FROM generate_series(1, 10) i; CREATE MATERIALIZED VIEW mv_foo AS SELECT * FROM foo_data; +CREATE MATERIALIZED VIEW mv_foo AS SELECT * FROM foo_data; +CREATE MATERIALIZED VIEW IF NOT EXISTS mv_foo AS SELECT * FROM foo_data; CREATE UNIQUE INDEX ON mv_foo (i); RESET ROLE; REFRESH MATERIALIZED VIEW mv_foo; |