On Tue, Jun 14, 2011 at 11:54 PM, Andy Chambers <achambers@xxxxxxxx> wrote: > Hi, > > What happens to cursors when new data is added to a table after you > start iterating > over its rows? > > For example, given the following loop... > > for rule in select tc.sid, tc.s, td.rule, td.returns > from tcell tc > inner join tcelldef td on (tc.p = td.p) > where tc.iasid = current_audit_sid() > or committed_sid in ( select committed > from tcellread tcr > where tc.sid = tcr.tcell ) > for update of tc loop > ... > end loop; > > some code in the loop might add a record into tcellread that causes the where > condition to become true for a row in which it was previously false. > Will the cursor > eventually see it? nope! merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
