Re: [HACKERS] Question about row visibility after locks

2002-11-09 Thread Stephan Szabo
On Sat, 9 Nov 2002, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > Basically, if I've got a select that's running using > > HeapTupleSatisfiesDirty so that I can see uncommitted rows > > and I block in the middle for another transaction (waiting > > to see if it commits the row I'

Re: [HACKERS] Question about row visibility after locks

2002-11-09 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Basically, if I've got a select that's running using > HeapTupleSatisfiesDirty so that I can see uncommitted rows > and I block in the middle for another transaction (waiting > to see if it commits the row I'm looking at) and that > transaction inserts an

[HACKERS] Question about row visibility after locks

2002-11-08 Thread Stephan Szabo
I've been wondering (and probably should look through the code, but figured asking would be faster) if there's any guarantee that I'll see rows inserted by a transaction I'm waiting on in the middle of a query. Basically, if I've got a select that's running using HeapTupleSatisfiesDirty so that I