EXPLAIN omits schema?
От | Dave Page |
---|---|
Тема | EXPLAIN omits schema? |
Дата | |
Msg-id | 466FB80F.4090707@postgresql.org обсуждение исходный текст |
Ответы |
Re: EXPLAIN omits schema?
Re: EXPLAIN omits schema? |
Список | pgsql-hackers |
I was just looking at implementing some query tuning/debugging features in pgAdmin, and was looking to use EXPLAIN output to get a list of the base tables involved in the users' query. Unfortunately though it doesn't include the schema name in the output which means I have no way of telling for sure which table is being referred to (even in a single query, consider SELECT * FROM s1.foo, s2.foo). Looking to fix this, a comment in src/backend/commands/explain.c indicates that this is intentional: /* We only show the rel name, not schema name */ relname = get_rel_name(rte->relid); Anyone know why? This seems like a bug to me given the ambiguity of possible output. Regards, Dave.
В списке pgsql-hackers по дате отправления: