BUG #16670: pgstattuple ERROR: relation "sql_implementation_info" does not exist

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16670: pgstattuple ERROR: relation "sql_implementation_info" does not exist
Дата
Msg-id 16670-4aa3d62f20dd7754@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16670: pgstattuple ERROR: relation "sql_implementation_info" does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16670
Logged by:          Marc Rechté
Email address:      mrechte@gmail.com
PostgreSQL version: 13.0
Operating system:   CentOS8
Description:

Hello,

I get an error with pgstattuple extension.

On PG13.0:
# select tablename,
(pgstattuple_approx(tablename::regclass)).approx_free_space from pg_tables
where schemaname = 'public'  and
(pgstattuple_approx(tablename::regclass)).approx_free_percent > 10;
ERROR:  relation "sql_implementation_info" does not exist

On PG12.3:
# select tablename,
(pgstattuple_approx(tablename::regclass)).approx_free_space from pg_tables
where schemaname = 'public'  and
(pgstattuple_approx(tablename::regclass)).approx_free_percent > 10;
ERROR:  relation "sql_packages" does not exist

Note that the where clause on approx_free_percent is the error cause.

Thanks


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16669: cant install postgresql13-server to rhel 6
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16670: pgstattuple ERROR: relation "sql_implementation_info" does not exist