Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1650jx11951
	for <pgsql-interfaces@postgresql.org>;
	Tue, 6 Feb 2001 00:00:45 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from ural2.hszk.bme.hu (ural2.hszk.bme.hu [152.66.130.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f11Kdsq87209
	for <pgsql-interfaces@postgresql.org>;
	Thu, 1 Feb 2001 15:39:54 -0500 (EST)
	(envelope-from kb136@hszk.bme.hu)
Received: (from kb136@localhost)
	by ural2.hszk.bme.hu (8.9.3/8.9.3) id VAA15760;
	Thu, 1 Feb 2001 21:39:51 +0100 (MET)
Date: Thu, 1 Feb 2001 21:39:51 +0100 (MET)
From: Kovacs Baldvin <kb136@hszk.bme.hu>
X-Sender: kb136@ural2
To: pgsql-interfaces@postgresql.org
Subject: Q on JDBC's resultset
Message-ID: <Pine.GSO.4.21.0102012132230.9884-100000@ural2>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200102/21
X-Sequence-Number: 973

Hello.

I looked in the source and have the feeling that if I
execute a SELECT statement, the whole resultset comes through
the network in one large bundle. 

Is it true?

It means that I cannot enable to use simple tablemodel and
table on top of an sql query, since it would be too slow to
download all of the data when opening it.

Anyway, how does the backend handles this? If I execute a query,
it copies the result immediately to a separate place?? So for
a SELECT *... query on a 2GB table results immediately in the
occupance of an pther two gigs?

Lastly, does anyone plans to work on updatable cursors? I think
that would make possibel to create read/write tablemodels in
Java.

Thanks,
Baldvin

p.s.: Does anyone knows if mysql supports updatable queries and
complete jdbc?