From f1fa6547867c01d0b8513e5d8b253ac4ae94ef81 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 31 Aug 2006 17:31:40 +0000 Subject: [PATCH] Clean up rather sloppy fix in HEAD for the ancient bug that CREATE CONVERSION didn't create a dependency from the new conversion to its schema. Back-patch to all supported releases. --- src/backend/catalog/pg_conversion.c | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/src/backend/catalog/pg_conversion.c b/src/backend/catalog/pg_conversion.c index 3941748e68..a46be475e3 100644 --- a/src/backend/catalog/pg_conversion.c +++ b/src/backend/catalog/pg_conversion.c @@ -18,6 +18,7 @@ #include "catalog/dependency.h" #include "catalog/indexing.h" #include "catalog/pg_conversion.h" +#include "catalog/pg_namespace.h" #include "catalog/pg_proc.h" #include "catalog/namespace.h" #include "utils/builtins.h" @@ -120,6 +121,12 @@ ConversionCreate(const char *conname, Oid connamespace, referenced.objectSubId = 0; recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL); + /* create dependency on namespace */ + referenced.classId = NamespaceRelationId; + referenced.objectId = connamespace; + referenced.objectSubId = 0; + recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL); + /* create dependency on owner */ recordDependencyOnOwner(ConversionRelationId, HeapTupleGetOid(tup), conowner); -- 2.39.5