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