![]() The name of the extension to be installed. Note that there is no guarantee that the existing extension is anything like the one that would have been created from the currently-available script file. This configuration gives the calling user the right to drop the extension, but not to modify individual objects within it.ĭo not throw an error if an extension with the same name already exists. In this case the extension object itself will be owned by the calling user, but the contained objects will be owned by the bootstrap superuser (unless the extension's script explicitly assigns them to the calling user). However, if the extension is marked trusted in its control file, then it can be installed by any user who has CREATE privilege on the current database. For many extensions this means superuser privileges are needed. ![]() ![]() Loading an extension ordinarily requires the same privileges that would be required to create its component objects. The user who runs CREATE EXTENSION becomes the owner of the extension for purposes of later privilege checks, and normally also becomes the owner of any objects created by the extension's script. CREATE EXTENSION additionally records the identities of all the created objects, so that they can be dropped again if DROP EXTENSION is issued. The script will typically create new SQL objects such as functions, data types, operators and index support methods. Loading an extension essentially amounts to running the extension's script file. There must not be an extension of the same name already loaded. ![]() CREATE EXTENSION loads a new extension into the current database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |