| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | ERROR: relation "sql_features" does not exist |
| Date: | 2021-04-26 16:57:17 |
| Message-ID: | CAFj8pRC0m4J_KgHVAeoks89990BxwQY1NoquCuYoZJQoOWx2fw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2021-04-26 17:00:21 | Re: compute_query_id and pg_stat_statements |
| Previous Message | Tom Lane | 2021-04-26 16:56:13 | Re: compute_query_id and pg_stat_statements |