Commitb83ba2e

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 parent1ad47e8 commitb83ba2eCopy full SHA for b83ba2e

File tree

-16

lines changed

-16

lines changed

Lines changed: 0 additions & 16 deletions

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

Comments

(0)