BUG #16539: About pg_logdir_ls() function and pg_ls_logdir()function

Started by PG Bug reporting formalmost 6 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16539
Logged by: yanliang lei
Email address: leiyanliang@highgo.com
PostgreSQL version: 12.1
Operating system: CentOS7.7
Description:

In the https://www.postgresql.org/docs/12/adminpack.html,there is a function
which name is pg_logdir_ls() ,but there is no this function name from psql
query(the following query),why?

postgres=# \df pg_ls_logdir
List of functions
Schema | Name | Result data type |
Argument data types | Type
------------+--------------+------------------+---------------------------------------------------------------------------+------
pg_catalog | pg_ls_logdir | SETOF record | OUT name text, OUT size
bigint, OUT modification timestamp with time zone | func
(1 row)

postgres=# \df pg_logdir*
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows) ---->>>there is no pg_logdir* function!!!

postgres=# select version();
version

---------------------------------------------------------------------------------------------------------
PostgreSQL 12.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-39), 64-bit
(1 row)

postgres=#

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16539: About pg_logdir_ls() function and pg_ls_logdir()function

On Monday, July 13, 2020, PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 16539
Logged by: yanliang lei
Email address: leiyanliang@highgo.com
PostgreSQL version: 12.1
Operating system: CentOS7.7
Description:

In the https://www.postgresql.org/docs/12/adminpack.html,there is a
function
which name is pg_logdir_ls() ,but there is no this function name from psql
query(the following query),why?

postgres=# \df pg_ls_logdir

https://www.postgresql.org/docs/12/functions-admin.html#FUNCTIONS-ADMIN-GENFILE

postgres=# \df pg_logdir*
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows) ---->>>there is no pg_logdir* function!!!

https://www.postgresql.org/docs/12/contrib.html

The commentary at the end of the TOC describes how to use the stuff
described in the “Additional Supplied Modules” section.

In short, you haven’t installed the function from adminpack but core
provide its own version.

David J.