Thread: Problem with psqlODBC on "Cache Size"

Problem with psqlODBC on "Cache Size"

From
Cleber Nardelli
Date:
Hi...

I lowered version 8.01.00.04 of driver ODBC, so that the problem with
the "Rollback you the Savepoint" was corrected.  In this in case that
the problem really is corrected, but now I have another problem.
In the configuration of driver I use the option "Use Declare/Fetch"
(necessary to use this option for the form as my system he makes the
readings), in the field "Cache Size" I inform "1" and ai any SQL that
I make only returns 1 row.  In version 7.03.02.00 this problem did not
occur, I had marked the option "I use Declare/Fetch" and 1 in "Cache
Size".

Tanks...

Cleber.

Re: Problem with psqlODBC on "Cache Size"

From
"Dave Page"
Date:

> -----Original Message-----
> From: Cleber Nardelli [mailto:clebernardelli@gmail.com]
> Sent: 10 October 2005 12:43
> To: pgsql-odbc@postgresql.org; Dave Page
> Subject: Problem with psqlODBC on "Cache Size"
>
> Hi...
>
> I lowered version 8.01.00.04 of driver ODBC, so that the problem with
> the "Rollback you the Savepoint" was corrected.  In this in case that
> the problem really is corrected, but now I have another problem.
> In the configuration of driver I use the option "Use Declare/Fetch"
> (necessary to use this option for the form as my system he makes the
> readings), in the field "Cache Size" I inform "1" and ai any SQL that
> I make only returns 1 row.  In version 7.03.02.00 this problem did not
> occur, I had marked the option "I use Declare/Fetch" and 1 in "Cache
> Size".

Use Declare/Fetch is known to be broken Atm. It is being worked on.

Regards Dave

Re: Problem with psqlODBC on "Cache Size"

From
Cleber Nardelli
Date:
Dave, I am with problems in this point on the access to postgre it saw ODBC.
I am needing to use the "ROLLBACK TO SAVEPOINT" in my application,
this already is ok in driver, but however now I have another problem
that is this of it "Uses Declare/Fetch".
I am needing very this functioning, therefore necessary to distribute
the program having access postgre to my customers.
I am very grateful for its attention.

Yours truly
Cleber

On 10/10/05, Dave Page <dpage@vale-housing.co.uk> wrote:
>
>
> > -----Original Message-----
> > From: Cleber Nardelli [mailto:clebernardelli@gmail.com]
> > Sent: 10 October 2005 12:43
> > To: pgsql-odbc@postgresql.org; Dave Page
> > Subject: Problem with psqlODBC on "Cache Size"
> >
> > Hi...
> >
> > I lowered version 8.01.00.04 of driver ODBC, so that the problem with
> > the "Rollback you the Savepoint" was corrected.  In this in case that
> > the problem really is corrected, but now I have another problem.
> > In the configuration of driver I use the option "Use Declare/Fetch"
> > (necessary to use this option for the form as my system he makes the
> > readings), in the field "Cache Size" I inform "1" and ai any SQL that
> > I make only returns 1 row.  In version 7.03.02.00 this problem did not
> > occur, I had marked the option "I use Declare/Fetch" and 1 in "Cache
> > Size".
>
> Use Declare/Fetch is known to be broken Atm. It is being worked on.
>
> Regards Dave
>


--
Cleber Nardelli
IPM Automação e Consultoria
9998-8670

Re: Problem with psqlODBC on "Cache Size"

From
"Victor Rivero"
Date:
What's the status of Declare/Fetch?

Regards,

Victor Rivero

----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "Cleber Nardelli" <clebernardelli@gmail.com>;
<pgsql-odbc@postgresql.org>
Sent: Monday, October 10, 2005 8:34 AM
Subject: Re: [ODBC] Problem with psqlODBC on "Cache Size"


>
>
> > -----Original Message-----
> > From: Cleber Nardelli [mailto:clebernardelli@gmail.com]
> > Sent: 10 October 2005 12:43
> > To: pgsql-odbc@postgresql.org; Dave Page
> > Subject: Problem with psqlODBC on "Cache Size"
> >
> > Hi...
> >
> > I lowered version 8.01.00.04 of driver ODBC, so that the problem with
> > the "Rollback you the Savepoint" was corrected.  In this in case that
> > the problem really is corrected, but now I have another problem.
> > In the configuration of driver I use the option "Use Declare/Fetch"
> > (necessary to use this option for the form as my system he makes the
> > readings), in the field "Cache Size" I inform "1" and ai any SQL that
> > I make only returns 1 row.  In version 7.03.02.00 this problem did not
> > occur, I had marked the option "I use Declare/Fetch" and 1 in "Cache
> > Size".
>
> Use Declare/Fetch is known to be broken Atm. It is being worked on.
>
> Regards Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>



Re: Problem with psqlODBC on "Cache Size"

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Victor Rivero
> Sent: 13 October 2005 02:04
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Problem with psqlODBC on "Cache Size"
>
> What's the status of Declare/Fetch?

Still undergoing surgery.

Regards, Dave

Re: Problem with psqlODBC on "Cache Size"

From
"Victor Rivero"
Date:
Thanks Dave.

Any Expected Date available?

We need this feature ASAP (not to rush anyone: stress on the "AP" part of
it) for a live system that outgrew acceptable performance w/o Declare/Fetch
(i.e. w/o cursors).

Thanks again. Regards, Victor Rivero.

----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "Victor Rivero" <vrivero@cantv.net>; <pgsql-odbc@postgresql.org>
Sent: Thursday, October 13, 2005 3:34 AM
Subject: RE: [ODBC] Problem with psqlODBC on "Cache Size"


>
>
> > -----Original Message-----
> > From: pgsql-odbc-owner@postgresql.org
> > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Victor Rivero
> > Sent: 13 October 2005 02:04
> > To: pgsql-odbc@postgresql.org
> > Subject: Re: [ODBC] Problem with psqlODBC on "Cache Size"
> >
> > What's the status of Declare/Fetch?
>
> Still undergoing surgery.
>
> Regards, Dave
>
>



Re: Problem with psqlODBC on "Cache Size"

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Victor Rivero
> Sent: 13 October 2005 14:34
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Problem with psqlODBC on "Cache Size"
>
> Thanks Dave.
>
> Any Expected Date available?
>
> We need this feature ASAP (not to rush anyone: stress on the
> "AP" part of
> it) for a live system that outgrew acceptable performance w/o
> Declare/Fetch
> (i.e. w/o cursors).
>

I hope by the end of the month at the latest, however, I'll have to
leave it for Anoop to give a more useful answer as he is the one working
on the problem.

Regards Dave

Declare/Fetch "Get Well Soon"

From
"Victor Rivero"
Date:

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Page
Sent: Jueves, 13 de Octubre de 2005 09:57 a.m.
Hello Dave,

Any update on Declare/Fetch? News from Anoop?  Date?

Many thanks. Regards Victor Rivero

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Victor Rivero
> Sent: 13 October 2005 14:34
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Problem with psqlODBC on "Cache Size"
>
> Thanks Dave.
>
> Any Expected Date available?
>
> We need this feature ASAP (not to rush anyone: stress on the
> "AP" part of
> it) for a live system that outgrew acceptable performance w/o
> Declare/Fetch
> (i.e. w/o cursors).
>

I hope by the end of the month at the latest, however, I'll have to
leave it for Anoop to give a more useful answer as he is the one working
on the problem.

Regards Dave