Re: [PATCHES] COPY view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] COPY view
Дата
Msg-id 23235.1156356556@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] COPY view  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
Ответы Re: [PATCHES] COPY view
Список pgsql-hackers
Zoltan Boszormenyi <zboszor@dunaweb.hu> writes:
> How about the callback solution for the SELECT case
> that was copied from the original? Should I consider
> open-coding in copy.c what ExecutorRun() does
> to avoid the callback?

Adding a DestReceiver type is a good solution ... although that static
variable is not.  Instead define a DestReceiver extension struct that
can carry the CopyState pointer for you.  You could also consider
putting the copy-from-view-specific state fields into DestReceiver
instead of CopyState, though this is a bit asymmetric with the relation
case so maybe it's not really cleaner.

BTW, lose the tuple_to_values function --- it's an extremely bad
reimplementation of heap_deform_tuple.  copy_dest_printtup also seems
coded without regard for the TupleTableSlot access API (read printtup()
to see what to do instead).  And what's the point of factoring out the
heap_getnext loop as CopyRelationTo?  It's not like that lets you share
any more code.  The inside of the loop, ie what you've called
CopyValuesTo, is the sharable part.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] COPY view
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: pgsql-patches reply-to (was Re: [PATCHES] selecting large result sets in psql using cursors)