| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com> |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Cristiano Duarte <cunha17(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [BUGS] BUG #2429: Explain does not report object's schema |
| Date: | 2006-05-16 08:47:12 |
| Message-ID: | 20060516084712.GA976@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Tue, May 16, 2006 at 09:15:13AM +0530, Gurjeet Singh wrote:
> I don't think Cristiano is asking for the schema_name in the
> EXPLAIN o/p. The request is for the table ALIASes to be shown in the
> o/p, which makes more sense than schema_name+table_name, since the
> same table can be used in the same query more than once.
As has been pointed out, aliases ave always been displayed. The OPs
problem was that he was using schema.tablename everywhere and explain
didn't distinguish between schema1.mytable and schema2.mytable. It was
suggested that he use aliases instead to make it work.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy | 2006-05-16 09:47:55 | Re: BUG #2419: could not reattach to shared memory |
| Previous Message | Peter Exner | 2006-05-16 08:04:22 | BUG #2440: TEMP TABLES in Postgres 8.1.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | winlinchu | 2006-05-16 09:25:45 | Help!!!! |
| Previous Message | Zeugswetter Andreas DCP SD | 2006-05-16 08:17:20 | Re: Compression and on-disk sorting |