On 4/6/04 3:55 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> The kludge solution I implemented was to write out all the data I
>> needed from table A to a file, then read that file and update table B.
>
> In theory at least, that should not be any faster than a WITH HOLD
> cursor, since you're effectively replicating the same functionality
> outside the database ...
Except for the "out of memory" thing...
Are you saying that once the first COMMIT completed, all COMMIT's after that
would function at normal speed - only the first one has to save the result
set?
Wes