pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: torikoshia <torikoshia@oss.nttdata.com>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Doc necessity for superuser privileges to execute pg_import_system_collations()
Date: Mon, 19 Jul 2021 11:45:57 +0900
Message-ID: <b7f484692a3e283710032e68b7f40617@oss.nttdata.com> (raw)

Hi.

It seems that only superusers can execute pg_import_system_collations(), 
but this is not mentioned in the manual.

Since other functions that require superuser privileges describe that in 
the manual, I think it would be better to do the same for consistency.

Thoughts?

-- 
Regards,

--
Atsushi Torikoshi
NTT DATA CORPORATION

Attachments:

v1-0001-doc-pg_import_system_collations-needs-superuser.patch (text/x-diff, 579B) download
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index ac6347a971..819f2c8914 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -26563,6 +26563,7 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup());
         be <literal>pg_catalog</literal>, but that is not a requirement; the
         collations could be installed into some other schema as well.  The
         function returns the number of new collation objects it created.
+        This function is restricted to superusers.
        </para></entry>
       </row>
      </tbody>

view thread (3+ messages)  latest in thread

Message-ID: <b7f484692a3e283710032e68b7f40617@oss.nttdata.com>
Permalink:  ../b7f484692a3e283710032e68b7f40617@oss.nttdata.com/
Also on:    postgresql.org/message-id/b7f484692a3e283710032e68b7f40617@oss.nttdata.com

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: torikoshia@oss.nttdata.com
  Subject: Re: Doc necessity for superuser privileges to execute pg_import_system_collations()
  In-Reply-To: <b7f484692a3e283710032e68b7f40617@oss.nttdata.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox