Skip site navigation (1) Skip section navigation (2)

Re: How can I configure the postgresql odbc to return 1 row at a time?

From: "Jerry Lam" <jlam(at)sandvine(dot)com>
To: "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: How can I configure the postgresql odbc to return 1 row at a time?
Date: 2005-04-13 15:09:38
Message-ID: 71837C040963F748B9B94E123A2896784F2615@mailserver.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks for the reply. I wonder if there is any documentation for all the possible configurations in posgresql odbc? 
Here is the list:

#define INI_DSN				DBMS_NAME

#define INI_KDESC			"Description"	/* Data source description */
#define INI_SERVER			"Servername"	/* Name of Server running PostgreSQL */
#define INI_PORT			"Port"		/* Port on which the Postmaster is listening */
#define INI_DATABASE			"Database"	/* Database Name */
#define INI_USER			"Username"	/* Default User Name */
#define INI_PASSWORD			"Password"	/* Default Password */
#define INI_DEBUG			"Debug" 	/* Debug flag */
#define INI_FETCH			"Fetch" 	/* Fetch Max Count */
#define INI_SOCKET			"Socket"	/* Socket buffer size */
#define INI_READONLY			"ReadOnly"	/* Database is read only */
#define INI_COMMLOG			"CommLog"	/* Communication to backend logging */
#define INI_PROTOCOL			"Protocol"	/* What protocol (6.2) */
#define INI_OPTIMIZER			"Optimizer"	/* Use backend genetic optimizer */
#define INI_KSQO			"Ksqo"		/* Keyset query optimization */
#define INI_CONNSETTINGS		"ConnSettings"	/* Anything to send to backend on successful connection */
#define INI_UNIQUEINDEX			"UniqueIndex"	/* Recognize unique indexes */
#define INI_UNKNOWNSIZES		"UnknownSizes"	/* How to handle unknown result set sizes */
#define INI_CANCELASFREESTMT		"CancelAsFreeStmt"
#define INI_USEDECLAREFETCH		"UseDeclareFetch"	/* Use Declare/Fetch cursors */

/*	More ini stuff */
#define INI_TEXTASLONGVARCHAR		"TextAsLongVarchar"
#define INI_UNKNOWNSASLONGVARCHAR	"UnknownsAsLongVarchar"
#define INI_BOOLSASCHAR			"BoolsAsChar"
#define INI_MAXVARCHARSIZE		"MaxVarcharSize"
#define INI_MAXLONGVARCHARSIZE		"MaxLongVarcharSize"

#define INI_FAKEOIDINDEX		"FakeOidIndex"
#define INI_SHOWOIDCOLUMN		"ShowOidColumn"
#define INI_ROWVERSIONING		"RowVersioning"
#define INI_SHOWSYSTEMTABLES		"ShowSystemTables"
#define INI_LIE				"Lie"
#define INI_PARSE			"Parse"
#define INI_EXTRASYSTABLEPREFIXES	"ExtraSysTablePrefixes"

#define INI_TRANSLATIONNAME		"TranslationName"
#define INI_TRANSLATIONDLL		"TranslationDLL"
#define INI_TRANSLATIONOPTION		"TranslationOption"
#define INI_DISALLOWPREMATURE		"DisallowPremature"
#define INI_UPDATABLECURSORS		"UpdatableCursors"
#define INI_LFCONVERSION		"LFConversion"
#define INI_TRUEISMINUS1		"TrueIsMinus1"
#define INI_INT8AS			"BI"
#define INI_BYTEAASLONGVARBINARY	"ByteaAsLongVarBinary"
#define INI_USESERVERSIDEPREPARE	"UseServerSidePrepare"
#define INI_LOWERCASEIDENTIFIER		"LowerCaseIdentifier"

Some of them have description (but too short to understand clearly what it will do) and some of them have no description at all... 

Please help,

Jerry

-----Original Message-----
From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
Sent: Monday, April 11, 2005 11:12 AM
To: Jerry Lam; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] How can I configure the postgresql odbc to return 1
row at a time?


--- Jerry Lam <jlam(at)sandvine(dot)com> wrote:
> Hi,
> 
> Is it possible to ask postgresql odbc driver to
> fetch the resulsets from the table one at a time
> instead of fetching all millions rows into memory?

Perhaps setting the "Use declare/fetch" driver option
to true will help you.  This will cause a server side
cursor to be used, which will return the rows in
blocks.  What controls the size of the blocks, I have
no idea; I've never messed with that.

> 
> Thank you,
> 
> Jerry
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2005-04-13 16:32:35
Subject: Re: How can I configure the postgresql odbc to return 1 row at a time?
Previous:From: Marc SoledaDate: 2005-04-13 09:21:34
Subject: VC++/MFC CRecordset problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group