Thread: Documentation sections does not match exactly

Documentation sections does not match exactly

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.4/contrib.html
Description:

Hi All,

https://www.postgresql.org/docs/9.4/sql-createextension.html says:
"Loading an extension requires the same privileges that would be required to
create its component objects. For most extensions this means superuser or
database owner privileges are needed."
While https://www.postgresql.org/docs/9.4/contrib.html says:
"CREATE EXTENSION module_name;
This command must be run by a database superuser."
So contrib page exactly pointing that superuser is a mandatory requirement
while createextension page leaves space for free interpretation.

Kind regards,
Slava

Re: Documentation sections does not match exactly

From
Tom Lane
Date:
=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> https://www.postgresql.org/docs/9.4/sql-createextension.html says:
> "Loading an extension requires the same privileges that would be required to
> create its component objects. For most extensions this means superuser or
> database owner privileges are needed."
> While https://www.postgresql.org/docs/9.4/contrib.html says:
> "CREATE EXTENSION module_name;
> This command must be run by a database superuser."
> So contrib page exactly pointing that superuser is a mandatory requirement
> while createextension page leaves space for free interpretation.

I don't see anything wrong here.  The CREATE EXTENSION page is giving
the general rule.  The page about contrib modules is saying you need
to be superuser to install those particular extensions, which is true
for the great majority of them (though maybe not every one, not sure).

            regards, tom lane