From 3505c8916b48c9466bee75963d859daa2e1d3c78 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 2 May 2014 16:51:31 -0400 Subject: [PATCH] deparse/core: qualify "=" operator in SPI queries Deparsing of CREATE VIEW was failing without this, because we remove pg_catalog from the search path. --- src/backend/utils/adt/ruleutils.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 24ade6cc20..09fa37785b 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -269,9 +269,9 @@ typedef struct * ---------- */ static SPIPlanPtr plan_getrulebyoid = NULL; -static const char *query_getrulebyoid = "SELECT * FROM pg_catalog.pg_rewrite WHERE oid = $1"; +static const char *query_getrulebyoid = "SELECT * FROM pg_catalog.pg_rewrite WHERE oid OPERATOR(pg_catalog.=) $1"; static SPIPlanPtr plan_getviewrule = NULL; -static const char *query_getviewrule = "SELECT * FROM pg_catalog.pg_rewrite WHERE ev_class = $1 AND rulename = $2"; +static const char *query_getviewrule = "SELECT * FROM pg_catalog.pg_rewrite WHERE ev_class OPERATOR(pg_catalog.=) $1 AND rulename OPERATOR(pg_catalog.=) $2"; /* GUC parameters */ bool quote_all_identifiers = false; -- 2.39.5