diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-02-22 14:42:45 -0500 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-02-22 14:46:19 -0500 |
| commit | 3e6b305d9e2a4616bf69e31b0b21ebbb844ba50e (patch) | |
| tree | e28d44546f3fbdeb0d41d76fac87bd99f6d4587c /src/backend/commands/view.c | |
| parent | 1ab9b012bdf1f106792fc523e21b9ca8299bb8ed (diff) | |
| download | postgresql-3e6b305d9e2a4616bf69e31b0b21ebbb844ba50e.tar.gz | |
Fix a couple of unlogged tables goofs.
"SELECT ... INTO UNLOGGED tabname" works, but wasn't documented; CREATE
UNLOGGED SEQUENCE and CREATE UNLOGGED VIEW failed an assertion, instead
of throwing a sensible error.
Latter issue reported by Itagaki Takahiro; patch review by Tom Lane.
Diffstat (limited to 'src/backend/commands/view.c')
| -rw-r--r-- | src/backend/commands/view.c | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/backend/commands/view.c b/src/backend/commands/view.c index 22dfc923cf..1f418e907e 100644 --- a/src/backend/commands/view.c +++ b/src/backend/commands/view.c @@ -465,6 +465,12 @@ DefineView(ViewStmt *stmt, const char *queryString) view->relname))); } + /* Unlogged views are not sensible. */ + if (view->relpersistence == RELPERSISTENCE_UNLOGGED) + ereport(ERROR, + (errcode(ERRCODE_SYNTAX_ERROR), + errmsg("views cannot be unlogged because they do not have storage"))); + /* * Create the view relation * |