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: (view raw, whole thread or download thread mbox)
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

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

Hiroshi Inoue

In response to


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-2017 The PostgreSQL Global Development Group