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
>> 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
> 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.
> Hiroshi Inoue
In response to
pgsql-odbc by date
|Next:||From: Ken Benson||Date: 2012-04-11 22:01:36|
|Subject: UPDATE table via ODBC fails.|
|Previous:||From: Hiroshi Inoue||Date: 2012-04-11 13:38:52|
|Subject: Re: Problem with Use Declare/Fetch|