Re: Table locks - Mailing list pgsql-general

From Tom Lane
Subject Re: Table locks
Date
Msg-id 26135.971116863@sss.pgh.pa.us
Whole thread Raw
In response to Re: Table locks  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Table locks  (Bruce Momjian <pgman@candle.pha.pa.us>)
Lock problem on Solaris  (Travis Bauer <trbauer@cs.indiana.edu>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> No spinlock.  I was going to just grab a snapshot as it existed.  If it
> changes while I am grabbing it, I just try again.

Unless, of course, you follow a now-dangling pointer and cause a backend
crash.  But even without that, how do you know whether you grabbed a
self-consistent snapshot or not?

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Table locks
Next
From: Bruce Momjian
Date:
Subject: Re: Win98