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

Bruce Momjian wrote:
> 
> Hiroshi Inoue wrote:
> > Bruce Momjian wrote:
> > >
> > > Peter Eisentraut wrote:
> > > > Bruce Momjian writes:
> > > >
> >
> > I don't understand what you two are discussing.
> > What's is SENSITIVE, INSENSITIVE or ASESNSITIVE ?
> 
> In SQL99 standard, I see:
> 
>          -  If the cursor is insensitive, then significant changes are not
>             visible.
> 
>          -  If the cursor is sensitive, then significant changes are
>             visible.
> 
>          -  If the cursor is asensitive, then the visibility of significant
>             changes is implementation-dependent.

While a cursor is open, another application inserted a
row which satisfies the condition to be contained in
the cursor and committed. Then
If the cursor is SENSITIVE, must it see the row ?
If the cursor is INSENSITIVE, it mustn't see the row ? 
regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/