Re: Analyze plan of foreign data wrapper

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Analyze plan of foreign data wrapper
Дата
Msg-id 1530220664.3220.2.camel@cybertec.at
обсуждение исходный текст
Ответ на Analyze plan of foreign data wrapper  (Mathieu PUJOL <mathieu.pujol@realfusio.com>)
Ответы Re: Analyze plan of foreign data wrapper
Список pgsql-general
Mathieu PUJOL wrote:
> I'am writing a foreign data wrapper. To avoid returning data for a column that is not used, I parse 'targetlist' and
'qual'of the Plan.
 
> I'am able to find Var nodes but I can't figure out how i could now if this node is related to a column my foreign
table.

For a Var v, v->varattno contains the attribute number of the column.
That is the same as the attnum column in pg_attribute.

If v->varattno == 0, it is a whole-row reference, like in

   SELECT mytab FROM mytab;

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: plperl and plperlu language extentsions
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: incorrect resource manager data checksum in record