Re: RETURNING syntax for COPY

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: RETURNING syntax for COPY
Дата
Msg-id 518A843A.3020408@vmware.com
обсуждение исходный текст
Ответ на Re: RETURNING syntax for COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: RETURNING syntax for COPY
Список pgsql-hackers
On 08.05.2013 19:44, Tom Lane wrote:
> Karol Trzcionka<karlikt@gmail.com>  writes:
>> as a continuation of my proposal expanding RETURNING syntax by
>> AFTER/BEFORE, there can be enough time to implement RETURNING for COPY.
>
> No there isn't; what you suggest would require FE/BE protocol
> extensions, making it several orders of magnitude more work than the
> other thing.

I'd imagine that the flow would go something like this:

BE    FE

CopyInResponseCopyDataCopyData...CopyDone
RowDescription
DataRow
DataRow
CommandComplete

A well-written client should be able to handle that. But if one expects 
the backend to always send a CommandComplete after CopyDone, it will get 
confused. Implementing that doesn't seem too difficult to me.

I agree that this is much more work than the UPDATE RETURNING 
BEFORE/AFTER, though. Not sure if that's a good or a bad thing.

- Heikki



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: RETURNING syntax for COPY
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RETURNING syntax for COPY