Queries used by ruleutils were not schema-proof.

tglsfdc · tglsfdc · commit 5a8ab29adf36 · 2002-05-28T22:16:15.000Z
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c
@@ -3,7 +3,7 @@
  *				back to source text
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.106 2002/05/18 21:38:40 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.107 2002/05/28 22:16:15 tgl Exp $
  *
  *	  This software is copyrighted by Jan Wieck - Hamburg.
  *
@@ -101,9 +101,9 @@ typedef struct
  * ----------
  */
 static void *plan_getrulebyoid = NULL;
-static char *query_getrulebyoid = "SELECT * FROM pg_rewrite WHERE oid = $1";
+static char *query_getrulebyoid = "SELECT * FROM pg_catalog.pg_rewrite WHERE oid = $1";
 static void *plan_getviewrule = NULL;
-static char *query_getviewrule = "SELECT * FROM pg_rewrite WHERE ev_class = $1 AND rulename = $2";
+static char *query_getviewrule = "SELECT * FROM pg_catalog.pg_rewrite WHERE ev_class = $1 AND rulename = $2";
 
 
 /* ----------

Original file line number	Diff line number	Diff line change
`@@ -3,7 +3,7 @@`
`3`	`3`	`* back to source text`
`4`	`4`	`*`
`5`	`5`	`* IDENTIFICATION`
`6`		`- * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.106 2002/05/18 21:38:40 tgl Exp $`
	`6`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.107 2002/05/28 22:16:15 tgl Exp $`
`7`	`7`	`*`
`8`	`8`	`* This software is copyrighted by Jan Wieck - Hamburg.`
`9`	`9`	`*`
`@@ -101,9 +101,9 @@ typedef struct`
`101`	`101`	`* ----------`
`102`	`102`	`*/`
`103`	`103`	`static void *plan_getrulebyoid = NULL;`
`104`		`-static char query_getrulebyoid = "SELECT FROM pg_rewrite WHERE oid = $1";`
	`104`	`+static char query_getrulebyoid = "SELECT FROM pg_catalog.pg_rewrite WHERE oid = $1";`
`105`	`105`	`static void *plan_getviewrule = NULL;`
`106`		`-static char query_getviewrule = "SELECT FROM pg_rewrite WHERE ev_class = $1 AND rulename = $2";`
	`106`	`+static char query_getviewrule = "SELECT FROM pg_catalog.pg_rewrite WHERE ev_class = $1 AND rulename = $2";`
`107`	`107`
`108`	`108`
`109`	`109`	`/* ----------`