Skip site navigation (1) Skip section navigation (2)

Re: Problem with Use Declare/Fetch

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Ken BensonDate: 2012-04-11 22:01:36
Subject: UPDATE table via ODBC fails.
Previous:From: Hiroshi InoueDate: 2012-04-11 13:38:52
Subject: Re: Problem with Use Declare/Fetch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group