aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2020-01-08 10:36:46 +0900
committerMichael Paquier <michael@paquier.xyz>2020-01-08 10:36:46 +0900
commit86949c2f120792a6cfcafee1f30cf4231085b6d8 (patch)
treef7ac19eacd5f1ce327720522e6af8cf00b5c1e52
parenta6f4f407ada026007d37ab9d494bb6380ec12527 (diff)
downloadpostgresql-86949c2f120792a6cfcafee1f30cf4231085b6d8.tar.gz
postgresql-86949c2f120792a6cfcafee1f30cf4231085b6d8.zip
Revert "Forbid DROP SCHEMA on temporary namespaces"
This reverts commit a052f6c, following complains from Robert Haas and Tom Lane. Backpatch down to 9.4, like the previous commit. Discussion: https://postgr.es/m/CA+TgmobL4npEX5=E5h=5Jm_9mZun3MT39Kq2suJFVeamc9skSQ@mail.gmail.com Backpatch-through: 9.4
-rw-r--r--src/backend/commands/dropcmds.c16
1 files changed, 0 insertions, 16 deletions
diff --git a/src/backend/commands/dropcmds.c b/src/backend/commands/dropcmds.c
index b936d6af6ce..f04f4f5f31e 100644
--- a/src/backend/commands/dropcmds.c
+++ b/src/backend/commands/dropcmds.c
@@ -26,7 +26,6 @@
#include "nodes/makefuncs.h"
#include "parser/parse_type.h"
#include "utils/builtins.h"
-#include "utils/lsyscache.h"
#include "utils/syscache.h"
@@ -117,21 +116,6 @@ RemoveObjects(DropStmt *stmt)
ReleaseSysCache(tup);
}
- /*
- * Prevent the drop of a temporary schema, be it owned by the current
- * session or another backend as this would mess up with the callback
- * registered to clean up temporary objects at the end of a session.
- * Note also that the creation of any follow-up temporary object would
- * result in inconsistencies within the session whose temporary schema
- * has been dropped.
- */
- if (stmt->removeType == OBJECT_SCHEMA &&
- isAnyTempNamespace(address.objectId))
- ereport(ERROR,
- (errcode(ERRCODE_WRONG_OBJECT_TYPE),
- errmsg("cannot drop temporary schema \"%s\"",
- get_namespace_name(address.objectId))));
-
/* Check permissions. */
namespaceId = get_object_namespace(&address);
if (!OidIsValid(namespaceId) ||