Commit0c046f8

committed

Revert "Forbid DROP SCHEMA on temporary namespaces"

This reverts commita052f6c, following complains from Robert Haas andTom Lane. Backpatch down to 9.4, like the previous commit.Discussion:https://postgr.es/m/CA+TgmobL4npEX5=E5h=5Jm_9mZun3MT39Kq2suJFVeamc9skSQ@mail.gmail.comBackpatch-through: 9.4

1 parent8de3b68 commit0c046f8Copy full SHA for 0c046f8

File tree

-16

lines changed

-16

lines changed

Lines changed: 0 additions & 16 deletions

Original file line number	Diff line number	Diff line change
`@@ -27,7 +27,6 @@`
`27`	`27`	`#include"nodes/makefuncs.h"`
`28`	`28`	`#include"parser/parse_type.h"`
`29`	`29`	`#include"utils/builtins.h"`
`30`		`-#include"utils/lsyscache.h"`
`31`	`30`	`#include"utils/syscache.h"`
`32`	`31`
`33`	`32`
`@@ -110,21 +109,6 @@ RemoveObjects(DropStmt *stmt)`
`110`	`109`	`ReleaseSysCache(tup);`
`111`	`110`	`}`
`112`	`111`
`113`		`-/*`
`114`		`- * Prevent the drop of a temporary schema, be it owned by the current`
`115`		`- * session or another backend as this would mess up with the callback`
`116`		`- * registered to clean up temporary objects at the end of a session.`
`117`		`- * Note also that the creation of any follow-up temporary object would`
`118`		`- * result in inconsistencies within the session whose temporary schema`
`119`		`- * has been dropped.`
`120`		`- */`
`121`		`-if (stmt->removeType==OBJECT_SCHEMA&&`
`122`		`-isAnyTempNamespace(address.objectId))`
`123`		`-ereport(ERROR,`
`124`		`-(errcode(ERRCODE_WRONG_OBJECT_TYPE),`
`125`		`-errmsg("cannot drop temporary schema \"%s\"",`
`126`		`-get_namespace_name(address.objectId))));`
`127`		`-`
`128`	`112`	`/* Check permissions. */`
`129`	`113`	`namespaceId=get_object_namespace(&address);`
`130`	`114`	`if (!OidIsValid(namespaceId)\|\|`

Comments

(0)