From: | Alexandre - Aldeia Digital <alepaes(at)aldeiadigital(dot)com(dot)br> |
---|---|
To: | |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problem with Use Declare/Fetch |
Date: | 2012-04-11 19:21:28 |
Message-ID: | 4F85D9B8.10804@aldeiadigital.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Hiroshi,
Em 11-04-2012 10:38, Hiroshi Inoue escreveu:
> Hi Alexandre,
>
> (2012/04/10 8:25), Alexandre - Aldeia Digital wrote:
>> Hi Hiroshi,
>>
>> Sorry for delay!
>>
>> I sent the links to download the logs directly in your e-mail.
>> I analyzed the logs and I believe that the error was in this cursor:
>>
>> [1168-47.972] stmt_with_params = 'declare "P00954" cursor for SELECT
>> T1.Fn04CodEmp(...)
>>
>> This query must return about 14k rows. But with use/declare fectch (in
>> this case, cache size = 10), returns only 10 rows.
>
> It seems OK to me. Psqlodbc driver fetches tuples using extended query
> other than the 1st fetch. You can see the following lines in many
> places
>
> SendExecuteRequest: plan_name=P00954 count=10
>
> and the query returns 14725 tuples as a result.
>
> [1168-332.835]end of tuple list -- setting inUse to false: this =
> 083A0810 SELECT 5
> ELECT 5
> [1168-332.835]_QR_next_tuple: 'C' fetch_total = 14725 & this_fetch = 5
>
Very strange. I will try again and send you the results.
>> I don't search in other areas, but if you need I can do this.
>>
>> Another doubt: My Rollback on erros is set to Transaction. But I can see
>> some SAVEPOINT/RELEASE statements. It's normal ?
>
> Yes the driver uses savepoint/rollback in some internal queries.
Ok.
> regards,
> Hiroshi Inoue
Best regards,
Alexandre
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Benson | 2012-04-11 22:01:36 | UPDATE table via ODBC fails. |
Previous Message | Hiroshi Inoue | 2012-04-11 13:38:52 | Re: Problem with Use Declare/Fetch |