REVOKE ALL ON FUNCTION nonexistant() FROM PUBLIC;

bmomjian · bmomjian · commit e6f02c8231f6 · 2002-07-18T04:50:10.000Z
Used to report that GRANT could not find function nonexistant.

Rod Taylor
diff --git a/src/backend/catalog/aclchk.c b/src/backend/catalog/aclchk.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.69 2002/06/20 20:29:26 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.70 2002/07/18 04:50:10 momjian Exp $
  *
  * NOTES
  *	  See acl.h.
@@ -389,7 +389,8 @@ ExecuteGrantStmt_Function(GrantStmt *stmt)
 		char		replaces[Natts_pg_proc];
 
 		oid = LookupFuncNameTypeNames(func->funcname, func->funcargs,
-									  true, "GRANT");
+									  true, stmt->is_grant ? "GRANT" : "REVOKE");
+
 		relation = heap_openr(ProcedureRelationName, RowExclusiveLock);
 		tuple = SearchSysCache(PROCOID,
 							   ObjectIdGetDatum(oid),

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.69 2002/06/20 20:29:26 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.70 2002/07/18 04:50:10 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`* NOTES`
`14`	`14`	`* See acl.h.`
`@@ -389,7 +389,8 @@ ExecuteGrantStmt_Function(GrantStmt *stmt)`
`389`	`389`	`char replaces[Natts_pg_proc];`
`390`	`390`
`391`	`391`	`oid = LookupFuncNameTypeNames(func->funcname, func->funcargs,`
`392`		`- true, "GRANT");`
	`392`	`+ true, stmt->is_grant ? "GRANT" : "REVOKE");`
	`393`	`+`
`393`	`394`	`relation = heap_openr(ProcedureRelationName, RowExclusiveLock);`
`394`	`395`	`tuple = SearchSysCache(PROCOID,`
`395`	`396`	`ObjectIdGetDatum(oid),`