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

Re: Problem with Use Declare/Fetch

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Alexandre - Aldeia Digital <alepaes(at)aldeiadigital(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problem with Use Declare/Fetch
Date: 2012-04-11 13:38:52
Message-ID: 4F85896C.2050402@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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

> 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.

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Alexandre - Aldeia DigitalDate: 2012-04-11 19:21:28
Subject: Re: Problem with Use Declare/Fetch
Previous:From: Alexandre - Aldeia DigitalDate: 2012-04-09 23:25:53
Subject: Re: Problem with Use Declare/Fetch

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