From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | EXPLAIN omits schema? |
Date: | 2007-06-13 09:25:35 |
Message-ID: | 466FB80F.4090707@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-06-13 09:36:28 | Re: Selecting a constant question: A summary |
Previous Message | Martijn van Oosterhout | 2007-06-13 07:03:52 | Re: Selecting a constant question: A summary |