From: Tom Lane <tgl@sss.pgh.pa.us>
To: viacheslav.pumpur@gmail.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: Documentation sections does not match exactly
In-reply-to: <154695611269.22750.3224630838168304588@wrigleys.postgresql.org>
References: <154695611269.22750.3224630838168304588@wrigleys.postgresql.org>
Comments: In-reply-to =?utf-8?q?PG_Doc_comments_form?=
 <noreply@postgresql.org>
	message dated "Tue, 08 Jan 2019 14:01:52 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <24456.1546968220.1@sss.pgh.pa.us>
Date: Tue, 08 Jan 2019 12:23:40 -0500
Message-ID: <24457.1546968220@sss.pgh.pa.us>
Precedence: bulk

=?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