Skip site navigation (1) Skip section navigation (2)

Re: BUG #2429: Explain does not report object's schema

From: Lars Haugseth <njus(at)larshaugseth(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2429: Explain does not report object's schema
Date: 2006-05-10 12:54:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-hackers
* cunha17(at)gmail(dot)com ("Cristiano da Cunha Duarte") wrote:
| Explain command does not report the schema of objects, so when using objects
| having the same name but in different schemas, they will apear as being the
| same object.

Don't know whether this would help in your situation, but you can make the
output of EXPLAIN disambiguous by using table aliases:

   FROM schema1.mytable AS mt1, schema2.mytable AS mt2
  WHERE 1=0

(The AS keyword is optional.)

The aliases will be included in the query plan output.

Lars Haugseth

"If anyone disagrees with anything I say, I am quite prepared not only to
 retract it, but also to deny under oath that I ever said it." -Tom Lehrer

In response to


pgsql-hackers by date

Next:From: Bernd HelmleDate: 2006-05-10 13:01:45
Subject: Re: BEGIN inside transaction should be an error
Previous:From: Dhanaraj MDate: 2006-05-10 12:06:18
Subject: Need some clarification

pgsql-bugs by date

Next:From: Cristiano DuarteDate: 2006-05-10 14:26:30
Subject: Re: BUG #2429: Explain does not report object's schema
Previous:From: Tom LaneDate: 2006-05-10 04:09:28
Subject: Re: BUG #2428: ERROR: out of memory, running INSERT SELECT statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group