Re: subtransactions and FETCH behaviour (was Re: PREPARE and transactions) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: subtransactions and FETCH behaviour (was Re: PREPARE and transactions)
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D12E@m0114.s-mxs.net
Whole thread Raw
List pgsql-hackers
> Well, the proposal of implementing it like holdable cursors means using
> a Materialize node which, if I understand correctly, means taking the
> whole result set and storing it on memory (or disk).

Would it help to hold the lock for a record that is the current cursor position,
iff this record was updated (and subsequently rolled back) by this subtxn,
and release that lock as soon as you fetch next ?

Andreas


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Bug with view definitions?
Next
From: Andreas Pflug
Date:
Subject: Re: Bug with view definitions?