Re: updatable result sets

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

Dave Cramer wrote:
> Glenn,
>
> How would you propose we do this ?
>
> Dave
> On Wed, 2004-03-17 at 11:20, Glenn Holmer wrote:
>
>>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?

OK, that's what I thought :)

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Paul Thomas 2004-03-17 18:07:38 Re: BYTEA with large files leads to OutOfMemory
Previous Message Dave Cramer 2004-03-17 16:59:21 Re: updatable result sets