SEO

#1 (**permalink**) 04-16-2008, 01:28 AM

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

#2 (**permalink**) 04-16-2008, 01:28 AM

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#3 (**permalink**) 04-16-2008, 01:29 AM

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Re: Problem with psqlODBC on "Cache Size"