Re: updateable cursors & visibility

Hiroshi Inoue wrote:
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> >
> > Hiroshi Inoue wrote:
> > > > > If the cursor is INSENSITIVE, it mustn't see the row ?
> > > >
> > > > Right.
> > >
> > > If so, isn't the difference between SENSITIVE and INSENSITIVE extreme ?
> >
> > Yes.
> >
> > > Why do you or Peter refer to ASENSITIVE little ?
> >
> > Not sure --- ASENSITIVE seems to be "do whatever you want", which is
> > always good.
> >
> > > And what does the following mean ? It is placed just before the
> > sentences
> > > you quoted first.
> > >
> > > If a cursor is open, and the SQL-transaction in which the cursor was
> > > opened makes a significant change to SQL-data, then whether that
> > > change is visible through that cursor before it is closed is
> > determined
> > > as follows:
> >
> > There seem to be two sections, one dealing with seeing change made by
> > the same transaction:
>
> May I ask again ?
> Must a SENSITIVE cursor see other applications' changes made
> while the cursor is open ?

I think I see what you are saying, that the spec talks about seeing your
own transactions changes, and about seeing things after your transaction
commits, but doesn't really talk about seeing other transactions changes
while you are in the cursor's transaction. Is that the point?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073