updatable result sets

From: Glenn Holmer <gholmer(at)weycogroup(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: updatable result sets
Date: 2004-03-17 16:20:07
Message-ID: 40587AB7.7060401@weycogroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I have updatable result sets working with the 7.4.1 driver against
a 7.3 backend, but I've noticed that when inserting a record, it
appears as the last record in the result set even if a sort order
was specified. Likewise, if ORDER BY NAME was specified and the
name field has changed, it stays in the same place in the set.

Is there any way to make these records appear in order without
re-reading the data by creating the result set over again?

--
____________________________________________________________
Glenn Holmer gholmer(at)weycogroup(dot)com
Programmer/Analyst phone: 414-908-1809
Weyco Group, Inc. fax: 414-908-1601

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-03-17 16:59:21 Re: updatable result sets
Previous Message Fuchs Clemens 2004-03-17 15:19:24 BYTEA with large files leads to OutOfMemory