From b7a86e4046ce480614a3adae0ddcc52d6673c020 Mon Sep 17 00:00:00 2001
From: Jan Wieck <JanWieck@Yahoo.com>
Date: Wed, 12 May 1999 17:04:47 +0000
Subject: Fixed wrong hasAggs when aggregate columns of view aren't selected.

Disabled ability of defining DISTINCT or ORDER BY on views.

Jan
---
 src/backend/rewrite/rewriteDefine.c | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

(limited to 'src/backend/rewrite/rewriteDefine.c')

diff --git a/src/backend/rewrite/rewriteDefine.c b/src/backend/rewrite/rewriteDefine.c
index 1053df421e..431006843f 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 $
  *
  *-------------------------------------------------------------------------
  */
@@ -317,6 +317,18 @@ DefineQueryRewrite(RuleStmt *stmt)
 		if (query->limitOffset != NULL || query->limitCount != NULL)
 			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.
 		 */
-- 
cgit v1.2.1