Re: EXPLAIN omits schema?
| От | Lukas Kahwe Smith |
|---|---|
| Тема | Re: EXPLAIN omits schema? |
| Дата | |
| Msg-id | 466FE485.3050002@pooteeweet.org обсуждение исходный текст |
| Ответ на | Re: EXPLAIN omits schema? (Stephen Frost <sfrost@snowman.net>) |
| Список | pgsql-hackers |
Stephen Frost wrote: > * Dave Page (dpage@postgresql.org) wrote: >> /* 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. > > I'd assume it's to keep the explain output smaller with the > expectation/assumption that in general you're going to know. A possible > work-around would be to just always provide table aliases for your > queries, as those are shown in the explain. I am hoping that once we have WITH RECURSIVE, we could optionally provide a normalized dump into a table of the EXPLAIN output, that could then be easily "connected" the the old output using WITH RECURSIVE. regards, Lukas
В списке pgsql-hackers по дате отправления: