ERROR: relation "sql_features" does not exist - Mailing list pgsql-hackers

From Pavel Stehule
Subject ERROR: relation "sql_features" does not exist
Date
Msg-id CAFj8pRC0m4J_KgHVAeoks89990BxwQY1NoquCuYoZJQoOWx2fw@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: relation "sql_features" does not exist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi

I tried to write a query that does lateral join between information_schema.tables and pgstattuple function.

select * from information_schema.tables, lateral(select * from pgstattuple(table_name::name)) s where table_type = 'BASE TABLE';

The query finished by strange error

postgres=# select * from information_schema.tables, lateral(select * from pgstattuple(table_name::name)) s where table_type = 'BASE TABLE';
ERROR:  relation "sql_features" does not exist

When I set search_path to information_schema, then the query is running. But there is not any reason why it should be necessary.

I found this issue on pg 11.11, but the same behavior is on master branch.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: compute_query_id and pg_stat_statements
Next
From: Bruce Momjian
Date:
Subject: Re: compute_query_id and pg_stat_statements