Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git
Date
Msg-id 5640892B.7060700@iki.fi
Whole thread Raw
In response to Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Responses Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git
List pgsql-odbc
On 11/04/2015 04:26 PM, Inoue, Hiroshi wrote:
>
>
> On 2015/11/04 20:04, Heikki Linnakangas wrote:
>> On 11/04/2015 09:48 AM, Inoue, Hiroshi wrote:
>>> Hi,
>>>
>>> I was able to reproduce it here.
>>> Because I can't understand the current code at once, please give me some
>>> time
>>> to solve the problem.
>>
>> I also started looking at this last week, and came up with a patch
>> that I think fixes it, but I got distracted before completing it and
>> replying here. So here's what I came up with...
>
> The solution seems to generate 2 transactions for 1 insertion.

Hmm, you're right, although that doesn't seem to be a new issue. The
09.03.0400 driver does the same, see attached logs from
log_statements=all. Would be nice to fix that, but it's a separate issue.

> The insertion seems to be rejected when ByteaAsLongVarBinary=1.

Oh. It works for me. How are you testing that?

- Heikki


Attachment

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git
Next
From: Heikki Linnakangas
Date:
Subject: Re: Materialized Views