Commit65192e0

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 parentb0b6196 commit65192e0Copy full SHA for 65192e0

File tree

-15

lines changed

-15

lines changed

Lines changed: 0 additions & 15 deletions

Original file line number	Diff line number	Diff line change
`@@ -101,21 +101,6 @@ RemoveObjects(DropStmt *stmt)`
`101`	`101`	`errhint("Use DROP AGGREGATE to drop aggregate functions.")));`
`102`	`102`	`}`
`103`	`103`
`104`		`-/*`
`105`		`- * Prevent the drop of a temporary schema, be it owned by the current`
`106`		`- * session or another backend as this would mess up with the callback`
`107`		`- * registered to clean up temporary objects at the end of a session.`
`108`		`- * Note also that the creation of any follow-up temporary object would`
`109`		`- * result in inconsistencies within the session whose temporary schema`
`110`		`- * has been dropped.`
`111`		`- */`
`112`		`-if (stmt->removeType==OBJECT_SCHEMA&&`
`113`		`-isAnyTempNamespace(address.objectId))`
`114`		`-ereport(ERROR,`
`115`		`-(errcode(ERRCODE_WRONG_OBJECT_TYPE),`
`116`		`-errmsg("cannot drop temporary schema \"%s\"",`
`117`		`-get_namespace_name(address.objectId))));`
`118`		`-`
`119`	`104`	`/* Check permissions. */`
`120`	`105`	`namespaceId=get_object_namespace(&address);`
`121`	`106`	`if (!OidIsValid(namespaceId)\|\|`

Comments

(0)