Re: Psql odbc driver version 8.01.01.00 doesn't remember "Cache size" option if it is set to 0 (to set "unlimited"). - Mailing list pgsql-bugs

From Dave Page
Subject Re: Psql odbc driver version 8.01.01.00 doesn't remember "Cache size" option if it is set to 0 (to set "unlimited").
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4E7DEBB@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Psql odbc driver version 8.01.01.00 doesn't remember "Cache size" option if it is set to 0 (to set "unlimited").  ("Cristiano Ansaloni" <ans@prosystem.it>)
List pgsql-bugs
=20


________________________________

    From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Cristiano Ansaloni
    Sent: 08 November 2005 15:35
    To: pgsql-bugs@postgresql.org
    Subject: [BUGS] Psql odbc driver version 8.01.01.00 doesn't
remember "Cache size" option if it is set to 0 (to set "unlimited").
=09
=09

    Psql odbc driver version 8.01.01.00 doesn't remember "Cache
size" option if it is set to 0 (to set "unlimited").=20=20

Cache size of 0/unlimited makes no sense. The cache is only used in
declare/fetch mode, so if you want to fetch all rows at once, just turn
off use declare/fetch.

    Instead, the "Maximum rows to retrieve" option in the Tab 3 of
pgAdmin options works good.=20=20

=09=20

pgAdmin III doesn't use ODBC, and besides, that option is not analagous
to psqlODBC's cache size setting in the slightest. I would suggest
reading the appropriate doc pages for each product.

Regards, Dave.

pgsql-bugs by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: ECPG: "char*" instead of "const char*" in ecpglib.h
Next
From: Diego Cattelan
Date:
Subject: initdb problem