From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Cristiano Duarte <cunha17(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [BUGS] BUG #2429: Explain does not report object's schema |
Date: | 2006-05-16 19:49:50 |
Message-ID: | 20060516194949.GE19937@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Cristiano Duarte wrote:
> SQL table aliases doesn't help locating the real place where the table is.
> If I have a table named "test" at the schema "place" and I do:
>
> "EXPLAIN SELECT * FROM place.test mytest"
>
> I will get:
>
> "Seq Scan on test mytest"
>
> With this output I know that "mytest" is an alias to "test", and that's
> great, much helpful than aliases only, but, where is "test"?
Since you created the mytest alias, you sure know where it's pointing
to. In fact I'd argue that this should instead display
Seq Scan on mytest
> I don't see too much harm if the output was:
>
> "Seq Scan on place.test mytest"
Not much harm there, but there will be plenty harm on other node types
where the output is already too wide.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Arjen van der Meijden | 2006-05-17 10:31:35 | BUG #2441: All useable indexes for an IN are used, not just one |
Previous Message | Gurjeet Singh | 2006-05-16 18:49:52 | Re: [BUGS] BUG #2429: Explain does not report object's schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2006-05-16 20:39:02 | Re: psql feature thought |
Previous Message | Gurjeet Singh | 2006-05-16 18:49:52 | Re: [BUGS] BUG #2429: Explain does not report object's schema |