Re: updateable cursors & visibility - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: updateable cursors & visibility
Date
Msg-id EKEJJICOHDIEMGPNIFIJMEDOLBAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: updateable cursors & visibility  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: updateable cursors & visibility  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: updateable cursors & visibility  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.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 ?

regards,
Hiroshi Inoue 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: updateable cursors & visibility
Next
From: Bruce Momjian
Date:
Subject: Re: updateable cursors & visibility