Обсуждение: 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". Tanks... Cleber.
> -----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
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
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 > >
> -----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
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 > >
> -----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
-----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