| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git |
| Date: | 2015-11-09 11:53:15 |
| Message-ID: | 5640892B.7060700@iki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| large-object-data-at-exec-log.txt | text/plain | 1.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2015-11-09 12:10:16 | Re: Materialized Views |
| Previous Message | Inoue, Hiroshi | 2015-11-04 14:26:34 | Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git |