Re: Trouble with COPY IN

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Trouble with COPY IN
Дата
Msg-id alpine.BSO.2.00.1007201455220.5084@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Trouble with COPY IN  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: Trouble with COPY IN
Re: Trouble with COPY IN
Список pgsql-jdbc

On Tue, 20 Jul 2010, Matthew Wakeling wrote:

> Okay, have investigated a little further. It seems that the server may be
> responding to the client a little too quickly with the "all done" message.
> Here is a sequence of events in core.v3.QueryExecutorImpl:
>
> We call startCopy(). It calls processCopyResults().
> In processCopyResults, we receive character G, and we lock.
>
> We call writeToCopy(). It calls processCopyResults().
> We receive character C.
> We receive character Z, and unlock.
>
> We call endCopy(), which tries to unlock and fails.
>
>
> So, should the unlocking happen elsewhere, or should endCopy not require a
> lock?

To me it seems like a protocol violation to receive CommandComplete(C) and
ReadyForQuery(Z) before we've issued CopyDone(c) and this should be fixed
server side.

Kris Jurka

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: Trouble with COPY IN
Следующее
От: Radosław Smogura
Дата:
Сообщение: Binary protocol support for JDBC