From 5813283d21c015b8ff076f2c0eb6cdb23351f46f Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Thu, 3 May 2001 17:47:49 +0000
Subject: [PATCH] Permissions were not checked correctly when one view invokes
 another. Per bug report from Lieven Van Acker, 5/2/01.

---
 src/backend/rewrite/rewriteHandler.c | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/src/backend/rewrite/rewriteHandler.c b/src/backend/rewrite/rewriteHandler.c
index dc84aa7d7c..bbbad59005 100644
--- a/src/backend/rewrite/rewriteHandler.c
+++ b/src/backend/rewrite/rewriteHandler.c
@@ -309,9 +309,11 @@ ApplyRetrieveRule(Query *parsetree,
 	Assert(subrte->relid == relation->rd_id);
 	subrte->checkForRead = rte->checkForRead;
 	subrte->checkForWrite = rte->checkForWrite;
+	subrte->checkAsUser = rte->checkAsUser;
 
 	rte->checkForRead = false;	/* no permission check on subquery itself */
 	rte->checkForWrite = false;
+	rte->checkAsUser = InvalidOid;
 
 	/*
 	 * FOR UPDATE of view?
-- 
2.39.5