diff options
| author | Jan Wieck <JanWieck@Yahoo.com> | 1999-05-12 17:04:47 +0000 |
|---|---|---|
| committer | Jan Wieck <JanWieck@Yahoo.com> | 1999-05-12 17:04:47 +0000 |
| commit | b7a86e4046ce480614a3adae0ddcc52d6673c020 (patch) | |
| tree | 1a717b2ef2044f7d2aa95ff05a6d9c1f1c4c9c69 /src/backend/rewrite/rewriteDefine.c | |
| parent | 79c2576f775b962c67cac136722c5c7cc98201aa (diff) | |
| download | postgresql-b7a86e4046ce480614a3adae0ddcc52d6673c020.tar.gz postgresql-b7a86e4046ce480614a3adae0ddcc52d6673c020.zip | |
Fixed wrong hasAggs when aggregate columns of view aren't
selected.
Disabled ability of defining DISTINCT or ORDER BY on views.
Jan
Diffstat (limited to 'src/backend/rewrite/rewriteDefine.c')
| -rw-r--r-- | src/backend/rewrite/rewriteDefine.c | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/src/backend/rewrite/rewriteDefine.c b/src/backend/rewrite/rewriteDefine.c index 1053df421ee..431006843f2 100644 --- a/src/backend/rewrite/rewriteDefine.c +++ b/src/backend/rewrite/rewriteDefine.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteDefine.c,v 1.27 1999/05/10 00:45:30 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteDefine.c,v 1.28 1999/05/12 17:04:46 wieck Exp $ * *------------------------------------------------------------------------- */ @@ -318,6 +318,18 @@ DefineQueryRewrite(RuleStmt *stmt) elog(ERROR, "LIMIT clause not supported in views"); /* + * DISTINCT on view is not supported + */ + if (query->uniqueFlag != NULL) + elog(ERROR, "DISTINCT not supported in views"); + + /* + * ORDER BY in view is not supported + */ + if (query->sortClause != NIL) + elog(ERROR, "ORDER BY not supported in views"); + + /* * ... and finally the rule must be named _RETviewname. */ sprintf(expected_name, "_RET%s", event_obj->relname); |