X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E872DB1D0 for ; Thu, 10 Nov 2005 16:33:58 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40794-02 for ; Thu, 10 Nov 2005 20:33:55 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gatefox.foxi.nl (foxi.xs4all.nl [194.109.246.192]) by svr1.postgresql.org (Postfix) with ESMTP id E6C4CDB1DC for ; Thu, 10 Nov 2005 16:33:54 -0400 (AST) Received: from techfox.foxi (techfox.foxi [192.168.0.79]) by gatefox.foxi.nl (8.13.3/8.13.3) with ESMTP id jAAKXj2V018682; Thu, 10 Nov 2005 21:33:45 +0100 From: Frank van Vugt Organization: Foxi Consultants in Technology BV To: Greg Stark Subject: Re: Incremental results from libpq Date: Thu, 10 Nov 2005 21:33:20 +0100 User-Agent: KMail/1.8 References: <4D426B54-E08F-4DE9-9776-D46610CA4968@slamb.org> <200511101751.55377.ftm.van.vugt@foxi.nl> <877jbgb8x5.fsf@stark.xeocode.com> In-Reply-To: <877jbgb8x5.fsf@stark.xeocode.com> Cc: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200511102133.20904.ftm.van.vugt@foxi.nl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.037 required=5 tests=[AWL=0.037] X-Spam-Score: 0.037 X-Spam-Level: X-Archive-Number: 200511/19 X-Sequence-Number: 5815 > > If I'm informed correctly then Oracle and others are generating > > the complete static result set on the server-side, which will then > > stay cached until all rows/chunks are fetched. > That's obviously not true. Try doing "select * from huge_table" on Oracle > and you'll see records start appearing immediately. Then it seems I haven't (been informed correctly) :) Now, given that OCI is offering some kind of asynchronous interface as well, how are they handling an error occuring after a partial result-set has been retrieved by the client? -- Best, Frank.