Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >>Sailesh Krishnamurthy wrote: >> >>>Does pgsql only record X locks on the individual tuples on-disk or >>>does it do so for S locks as well ? > > >>We don't need to shared lock individual rows because of MVCC --- well, >>we sort of do by recording our xid in our proc structure, so folks don't >>change things underneath us. We prevent expired rows from disappearing >>from the disk by others looking at our proc start xid. > > > This is actually an issue though. Row-level shared locks would be > really nice to have for foreign-key handling. Right now we have to > use X locks for those, and that leads to deadlocking problems for > applications.
Yes! Yes! It's the last big hurdle for an otherwise excellent RI implementation... Just wanted "Joe-user's" enthusiasm for row-level S locks registered somewhere... :-) Mike Mascari [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
