Re: RelOptInfo->reltargetlist

Lists: pgsql-hackers
From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: RelOptInfo->reltargetlist
Date: 2007-08-20 09:21:01
Message-ID: 200708201121.01356.fluca1978@infinito.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi all,
apologize if this is a trivial question but I'd like to understand what values
are stored in the RelOptInfo->reltargetlist or, better, how I can check such
values in the information schema to understand what they refer to. I've tried
to look in the pg_attribute table but I was not able to find a match. In other
words, how can I check what is the oid of the listcell pointing to in the
database schema?

Thanks,
Luca


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luca Ferrari <fluca1978(at)infinito(dot)it>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RelOptInfo->reltargetlist
Date: 2007-08-20 13:45:57
Message-ID: 29097.1187617557@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Luca Ferrari <fluca1978(at)infinito(dot)it> writes:
> apologize if this is a trivial question but I'd like to understand what values
> are stored in the RelOptInfo->reltargetlist or, better, how I can check such
> values in the information schema to understand what they refer to. I've tried
> to look in the pg_attribute table but I was not able to find a match. In other
> words, how can I check what is the oid of the listcell pointing to in the
> database schema?

That list doesn't contain OIDs ... it contains Var nodes.

regards, tom lane