On Wed, Jan 19, 2011 at 7:10 PM, Tom Lane <t...@sss.pgh.pa.us> wrote:
> frank joerdens <fiskad...@gmail.com> writes:
>> I was just experimenting with debug logging on 8.3 and am finding that
>> I can't get it to log the table names involved in a given query, it
>> will always print the table alias used in your join instead, e.g.
>
> I don't know why you think that debug_print_plan is meant to do any such
> thing; it isn't meant to be useful to end users at all.  You could get
> the table identity from the relation OID that's in the plan tree, but
> the name is not there.

Oh, that's great - the OID will do just fine (missed that it was there). Thanks!

Regards,

Frank

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to