From 79c3ae59de73b43916b789216ea0b16117b5a210 Mon Sep 17 00:00:00 2001
From: Petr Jelinek <pjmodos@pjmodos.net>
Date: Sat, 20 Dec 2014 09:08:09 +0100
Subject: [PATCH] deparse: Fix CREATE CONVERSION.

---
 src/backend/tcop/deparse_utility.c |  2 +-
 src/backend/utils/cache/syscache.c | 11 +++++++++++
 src/include/utils/syscache.h       |  1 +
 3 files changed, 13 insertions(+), 1 deletion(-)

diff --git a/src/backend/tcop/deparse_utility.c b/src/backend/tcop/deparse_utility.c
index 464a210a8e..f0c693225d 100644
--- a/src/backend/tcop/deparse_utility.c
+++ b/src/backend/tcop/deparse_utility.c
@@ -3876,7 +3876,7 @@ deparse_CreateConversion(Oid objectId, Node *parsetree)
 	Form_pg_conversion conForm;
 	ObjTree	   *ccStmt;
 
-	conTup = SearchSysCache1(CONDEFAULT, ObjectIdGetDatum(objectId));
+	conTup = SearchSysCache1(CONOID, ObjectIdGetDatum(objectId));
 	if (!HeapTupleIsValid(conTup))
 		elog(ERROR, "cache lookup failed for conversion with OID %u", objectId);
 	conForm = (Form_pg_conversion) GETSTRUCT(conTup);
diff --git a/src/backend/utils/cache/syscache.c b/src/backend/utils/cache/syscache.c
index 94d951ce05..a0dca2a6c7 100644
--- a/src/backend/utils/cache/syscache.c
+++ b/src/backend/utils/cache/syscache.c
@@ -323,6 +323,17 @@ static const struct cachedesc cacheinfo[] = {
 		},
 		8
 	},
+	{ConversionRelationId,		/* CONOID */
+		ConversionOidIndexId,
+		1,
+		{
+			ObjectIdAttributeNumber,
+			0,
+			0,
+			0
+		},
+		8
+	},
 	{ConstraintRelationId,		/* CONSTROID */
 		ConstraintOidIndexId,
 		1,
diff --git a/src/include/utils/syscache.h b/src/include/utils/syscache.h
index f97229fcc0..d60936746a 100644
--- a/src/include/utils/syscache.h
+++ b/src/include/utils/syscache.h
@@ -50,6 +50,7 @@ enum SysCacheIdentifier
 	COLLOID,
 	CONDEFAULT,
 	CONNAMENSP,
+	CONOID,
 	CONSTROID,
 	CONVOID,
 	DATABASEOID,
-- 
2.39.5